select all names starting with "C"

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

select all names starting with "C"

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-06-17 : 08:10:50

Andy writes "Can you please assist. I would like to run a select from an asp page where I select all names from a table that start with a letter that is selected from the asp page.

Any help would be appreciated.

regards

Andy"

dsdeming

479 Posts

Posted - 2003-06-17 : 08:27:10

Try

SELECT columns
FROM table
WHERE LEFT( name, 1 ) = 'C'

or

SELECT columns
FROM table
WHERE name LIKE 'C%'

Dennis

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources