like statement in sql server

Question

0.00/5 (No votes)

See more:

I want to display only the name of employees that starts only with
"San".But when i am using the "Like" statement in sql i shows ,all the names that is having the letters "San" continuously.

My code is as follows...

select * from tabName where empName like "San%"

please help Me to get the names that only starts with "San"

Eg. Output is
the table contains the following EmpName

1.santhanam
2.Santhose
3.Magesan

If i use the above query,It will display all the names.But I want to get only the names That are starts with "San".I need the following names,

1.santhanam
2.Santhose

Thanks in advance friends.........

Posted 20-Nov-12 19:02pm

Rohini Palanichamy

Add a Solution

Comments

__TR__ 21-Nov-12 1:21am

Your query seems to be working correctly when I tried it.

CREATE TABLE #SampleTable
(
ID INT,
EmpName VARCHAR(100)
)

INSERT INTO #SampleTable
SELECT 1, 'santhanam' UNION ALL
SELECT 2, 'Santhose' UNION ALL
SELECT 3, 'Magesan'

select * from #SampleTable where empName like 'San%'

DROP TABLE #SampleTable

Rohini Palanichamy 21-Nov-12 1:53am

What i need is i want to get only the names that starts with "San"

__TR__ 21-Nov-12 2:36am

Try
select * from tabName where empName like 'San %'

2 solutions

Solution 2

SQL

select * from tablename where empName like 'san_%'

Posted 20-Nov-12 21:43pm

Rohini Palanichamy

Updated 20-Nov-12 23:15pm

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bhushan Shah1988 · Accepted Answer · 2012-11-20T20:09:00

Solution 1

you can use your query something like below if number of starting characters are fix :

SQL

select * from tabName where left(EmpName,3) = 'San'

Posted 20-Nov-12 20:09pm

Bhushan Shah1988

Comments

Rohini Palanichamy 21-Nov-12 3:43am

It is also working fine Mr.Bhushan.