Thread: MSSQL charindex HELP !
View Single Post
•
•
Join Date: Feb 2008
Posts: 35
Reputation: huangzhi is an unknown quantity at this point 
Solved Threads: 11
huangzhi huangzhi is offline Offline
Light Poster

Re: MSSQL charindex HELP !

 
0
  #2
Oct 11th, 2008
Change your Select check to:
charindex(' ' + uzip + ' ',' ' + 'S10 S11 S7 S17 S8 S3 S30' + ' ') > 0

This code will check 'S1' <> 'S10'
Hence Wijaya
www.ex-Soft.tk
Reply With Quote