find a string between numeric in a column using SQL Query

[jeyanthi]

Hi need help with the query in SQL. let say i have a column that has 2000 data.. i just need to show the data that has A  at the strating of the data. For example:

A100001

W23456

A234444

I just need to show all the data got "A" at the start.

Thank u

[tst]

I don't think there is any standard command, so you will need to search for the pattern matching commands of your DBMS.

In SQL Server the keyword is "like", so your query would be Select col1 from tbl1 where col1 like 'A%'

[jeyanthi]

Thank You :womanhappy: