
November 7th, 2012, 09:38 PM
|
|
Registered User
|
|
Join Date: Oct 2012
Posts: 4
Time spent in forums: 1 h 30 m 45 sec
Reputation Power: 0
|
|
Suppose i have this query
select * from northwind where name like 'A%'
this would show results which are like:
APRIL
APPLE
ASADSAD
AND
(all that starts with A)
now for your question, I SUPPOSE that all your data has @@[]A
where @ = any digit or letter, followed by [] which indicates open space and A which is an end statement, you could use
select * from northwind where name like '%A'
it would show
A1 A
b2 A
c3 A
and so forth,
or you would use,
select * from northwind where name like 'S% A'
this would produce
S1 A
S2 A
S3 A
S4 A
I HOPE THIS HELPED 
|