February 27, 2013 at 12:57 pm
I am having, for some reason, a hard time figuring out how to tackle a problem that I have. We have a field in our CRM that has a persons Current Position and Desired Position. The format for the data is
"DIR, ADM; DIR, VP, MGR". The semicolon is what determines the split.
I have a list of what these values should be "AA", "CEO", "DIR", etc....They are 2-4 characters in length. The database field is nvarchar(50).
I need to pull all records that don't have one of the 34 valid values.
So for example, if a record has the following "Director" in it. The query should return it.
I should be able to do this, but am blanking. Help?!? TIA.
Tim
February 27, 2013 at 1:27 pm
Nevermind, sorry for the noise. It apparently has been a rough day. I sat here looking at my TSQL and realized I put OR instead of AND. What was I thinking.....I must not have been.
Have a great day. Again sorry for the noise.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply