Member Avatar for yorks

Hi all

I am pretty new to MSSQL and have a problem. The solution is probably very simple but I cant find it :)

I have a database field ZIP, I also have string with consists of a number of UK part postcodes eg

'S10 S11 S7 S17 S8 S3 S30'

I want to perform a SELECT check if the database field ZIP is in the string. I have used CHARINDEX as follows

charindex(uzip,'S10 S11 S7 S17 S8 S3 S30') > 0

BUT the problem is if the database field ZIP is , say S1 then it still finds it in the string because S10 in there which is obvioulsy incorrect

any help would be much appreciated

Thanks

  • 2 Contributors
  • 1 Reply
  • 206 Views
  • 19 Hours Discussion Span
  • Latest Post Latest Post by huangzhi
Member Avatar for huangzhi

Change your Select check to:
charindex(' ' + uzip + ' ',' ' + 'S10 S11 S7 S17 S8 S3 S30' + ' ') > 0

This code will check 'S1' <> 'S10'

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.