?? on Finding records with caharacters before and after in a string??

SQLServerCentral » Latest topics

?? on Finding records with caharacters before and after in a string??

Hi

Looking to find record that contain characters berfore and after and ignore the ones in the middle.

For example

Here are two records
 looking to pickup anything that contains '1NNNNNN202'
where I only want to loo

more info...