November 7th, 2012, 09:38 PM
Join Date: Oct 2012
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:
(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
and so forth,
or you would use,
select * from northwind where name like 'S% A'
this would produce
I HOPE THIS HELPED