June 1, 2009 at 2:55 pm
GSquared (6/1/2009)
Jack Corbett (6/1/2009)
Lynn Pettis (6/1/2009)
Okay, now tell us what you are trying accomplish. I can't see a correlation between your data and the query from your original post. Possible that I am slightly blind as I am a soccer referee, and been accussed of being blind before.Yeah but with those ears you can pick up just about anything via sound. :w00t:
To answer the OP's original question, do you get any results back from this code:
Select * From testcases where Scenarionam Like '%[Change6]-[Existing Customer]%'
Original question is about equals, not "Like". If you want to use "Like", you'll have to escape some of the characters.
Right, but I suggested like to try to get the actual data that might be in the database so we/he can see why there is not a result with "=".
Right, since I don't use brackets usually I forget that they are wildcards in the like, so you need to escape the opening bracket ([). Here's the right query:
Select * From #testcases where Scenarioname Like '%[[]change6]-[[]Existing Customer]%'
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing post 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply