mssql statment in visual basi c2005 experess edition

[bryantlee5311]

i am using mssql which build in in the visual basic 2005 web developer express edition..i have a question here to ask..which is how to write the like statement which depend on user input..such as if user input b..i will show all name which start with b on the table and if user key in c, will list down all start with c's name.
Here the mssql normal statment which is
SELECT *
FROM employee
WHERE employeename Like 'a%'

dat is all start with a right~wad bout a until z?

[debasisdas]

Your sql statemnet should work perfectly ?

[ck9663]

i am using mssql which build in in the visual basic 2005 web developer express edition..i have a question here to ask..which is how to write the like statement which depend on user input..such as if user input b..i will show all name which start with b on the table and if user key in c, will list down all start with c's name.
Here the mssql normal statment which is
SELECT *
FROM employee
WHERE employeename Like 'a%'

dat is all start with a right~wad bout a until z?

Check this out.

-- CK