Query Data With....

Z

zyus

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
 
W

wangaiguo

zyus said:
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
Click to expand...


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

Albert D. Kallal

zyus said:
Tried...but failed..
Click to expand...


Try:

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

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