Dear All

I need to cerate a SP that SELECTS all the records from a table WHERE the first letter of each records starts with 'A' or 'B' or 'C' and so on. The letter is passed via a parameter from a aspx web page, I was wondering that someone can help me in the what TSQL to use I am not looking for a solution just a poin in the right direction. Can you help.

Thanks Ross

SELECT *

FROM table

WHERE columnName LIKE 'A%'

@Letter  Varchar(1) 

SELECT *

FROM YourTableName

WHERE YourColumnName LIKE  @Letter + '%'

Thanks All

 Got it to work using

SELECT @param = @param + '%'

SELECT ColName

FROM Table

WHERE ColName Like @param

Ross