Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with Query using wildcards 1

Status
Not open for further replies.
Jan 22, 2003
92
US
I am trying to pull all data starting with SS. I am using
Like 'SS *' and = 'SS *'
and neither are working. Please help.
 
Hi,

Use '%' instead of '*'

Select * from TBL where fld
Like 'SS%'

Sunil
 
That is not working. Is there some type of default I need to change.
 
If you post your sql statment maybe we can look at it and see what the problem is. Sunila's query should work fine.

Matt
 
Thank you Sunila7, this worked for me as I had the same problem.
 
I don't know whether it's in the query but you do have a trailing space character after the 'ss' in your WHERE clause, so the query is looking for items starting SS followed by a space character, not just starting SS.


Rhys
Thought out... Maybe,
Opinionated... Probably
But it is only an opiniion!
 
Thank you so much. It worked for me. It is so strange. When I entered it in criteria it would not work. When I typed out the Select statement it worked perfectly.

Thanks again,
Wf
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top