LIKE AND OR OPERATOR - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

LIKE AND OR OPERATOR

Author

Topic

vndnsingh2007
Starting Member

2 Posts

Posted - 2007-06-16 : 01:43:50

Hi ,
This is my first message on this forum. Well, I want to write a query which finds the length of the employee names whose name starts with J, A or S?.

This is what I did:

SELECT LENGTH(ENAME) FROM EMP
WHERE ENAME LIKE 'A%' OR LIKE 'J%' OR LIKE 'S%'

This query does not work. Can anyone tell me what is wrong with it?

Thanks,

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-06-16 : 01:48:36

[code]
SELECT LENGTH(ENAME) FROM EMP
WHERE ENAME LIKE 'A%' OR ENAME LIKE 'J%' OR ENAME LIKE 'S%'
[/code]

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-16 : 02:07:23

Also LENGTH is for front end and LEN for backend

SELECT LEN(ENAME) FROM EMP
WHERE ENAME LIKE 'A%' OR ENAME LIKE 'J%' OR ENAME LIKE 'S%'

Madhivanan

Failing to plan is Planning to fail

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-06-16 : 11:39:39

quote:
Originally posted by madhivanan

Also LENGTH is for front end and LEN for backend

SELECT LEN(ENAME) FROM EMP
WHERE ENAME LIKE 'A%' OR ENAME LIKE 'J%' OR ENAME LIKE 'S%'

Madhivanan

Failing to plan is Planning to fail

Yes

Thanks for catching that..

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources