Conditional where clause - 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

SQL Server 2000 Forums

Transact-SQL (2000)

Conditional where clause

Author

Topic

Dirty_Howi
Starting Member

12 Posts

Posted - 2005-06-08 : 09:53:49

i cant' seem to get it to work, and i KNOW my programmer is showing, but what i need is something along the lines of

select fname, lastname, servCode
from staff
where left(servcode,1)<>'w' or servcode<>'00002'

the second part works, servcode<>'00002', but the left command is giving me fits.

any help greatly appreciated, as this is one of the last hurdles i have to solve to complete the project.

When i'm right, no one remembers, when i'm wrong no one forgets.

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2005-06-08 : 09:55:12

what is servcode, and what kind of 'fits' is it giving??

you've gotta be clear to get a good answer

Corey

Secret Service Agent: Mr. President, you're urinating on me.
President Lyndon Johnson: I know I am. It's my prerogative.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-06-08 : 09:56:59

so what kind of problem do you have??
where left(servcode,1)<>'w'
will return all data that doesn't begin with 'w'.

Go with the flow & have fun! Else fight the flow

Dirty_Howi
Starting Member

12 Posts

Posted - 2005-06-08 : 10:01:04

servcode (alias, not real field name, cause i cant remember the real field name right now :) ) is used to distinguish between fulltime salaried employees, part time hourly employees and contractors. full time start with a 0, parttime start with a W, and contractors are all 00002.

it throws an error when i try to save the SP i am using to populate a tree....exact error i can go get if needed.

When i'm right, no one remembers, when i'm wrong no one forgets.

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2005-06-08 : 10:04:41

we need the exact error in this case...

Corey

Secret Service Agent: Mr. President, you're urinating on me.
President Lyndon Johnson: I know I am. It's my prerogative.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources