How to make a case senstive query and how to search for a wild card

  • Thread starter Thread starter enders
  • Start date Start date
E

enders

Hi,

I would like make the following query

select * from table where name like '*a*'
(give me all the rows where name contains a lowercase 'a')

and

select * from table where name like '*?*'
(give me all the rows where name contains a question mark)

I checked out the KB and did find somethings using strcomp or
converting it to Hex but it doesn't solve the problem when looking
in a value.

Any suggestions are welcome

With regards,

Constantijn Enders
MCSD.NET
 
You might try queries whose SQL look something like this:

SELECT * FROM
WHERE InStr(1, [name], "a", 0) <> 0

and

SELECT * FROM
WHERE [name] LIKE "*[?]*"
 
Brian Camire said:
You might try queries whose SQL look something like this:

SELECT * FROM
WHERE InStr(1, [name], "a", 0) <> 0

and

SELECT * FROM
WHERE [name] LIKE "*[?]*"
Click to expand...


Thanks for the solutions

CE
 
Back
Top