Query Data With....

[Guest]

I hv this table

Cust ID
A 123-45
B 123344
C 1-2-45
D 1 2227

Q,

How to find cust ID with - only or those with spaces

Thanks

 

[wangaiguo]

I hv this table

Cust ID
A 123-45
B 123344
C 1-2-45
D 1 2227

Q,

How to find cust ID with - only or those with spaces

Thanks

select * from tablename where id like '%-%'

 

[Guest]

Tried...but failed..

select * from tablename where id like '%-%'

 

[Albert D. Kallal]

Tried...but failed..

Try:

select * from tablename where id like "*-*"

Depending on your ms-access settings, % is not always considered a wild
card....