Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select statement

Status
Not open for further replies.
grecon

grecon

Technical User
Joined
Mar 8, 2007
Messages
78
Location
US
Hi I'm new to SQL and I need a SQL statement to retrieve certain records, all I want to do is select customers whos CUST.USERCODE3 <> to 1F 1 and CP How would I write that?
 
Sort by date Sort by votes
Try....

Where CUST.USERCODE3 Not In ('1F','1','CP')

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question Question
select a single row based on conditions in multiple rows
Replies
3
Views
1K
SashaBuilder3
SashaBuilder3
grnzbra
  • Locked
  • Question Question
Create Function Within IF statement.
Replies
4
Views
2K
mikrom
mikrom
leifoet
  • Locked
  • Question Question
Error in Select query
Replies
14
Views
1K
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
772
grnzbra
grnzbra
Auguy
  • Locked
  • Question Question
Using UDF In Select, Bad Idea?
Replies
3
Views
577
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top