I have a column in a table titled MCDE that houses three characters like BAN or ATL for each record. I need to be able to create a stored procedure that selects only the MCDE that begins with a certain letter. Example: ATL would be selected if I needed all MCDE's beginning with the letter A. <BR><BR>I was able to write a stored procedure that that only pulls distinct MCDE's but need it to also pull only by letter. Here is the stored procedure I started with:<BR><BR>CREATE PROCEDURE dbo.GetMCDEMembers<BR>AS<BR> SET NOCOUNT ON<BR> select distinct MCDE from NIMDATA order by MCDE<BR> <BR> RETURN<BR>GO<BR><BR>Thanks in advance for your help!