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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Syntax error - help ! 1

Status
Not open for further replies.
rabinski

rabinski

Programmer
May 13, 2005
21
GB
update table
set id= 55,
name = 'jo',
name2 = 'smith'
where ISNULL(postcode,'none'),
LEFT(ContactPostCode,3) IN ('L60','L61','L98','L97')

I know it must be obvious ;@)

cheers guys !
 
Sort by date Sort by votes
update table
set id= 55,
name = 'jo',
name2 = 'smith'
where ISNULL(postcode,'none') [red]= something[/red]
[red]And[/red] LEFT(ContactPostCode,3) IN ('L60','L61','L98','L97')

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

f0rg3tfu1
  • Locked
  • Question
PLSQL Package Help
Replies
0
Views
201
f0rg3tfu1
f0rg3tfu1
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
506
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
283
Andrzejek
Andrzejek
Virendra Yaduvanshi
  • Locked
  • Question
SSRS - Subscription page error
Replies
0
Views
107
Virendra Yaduvanshi
Virendra Yaduvanshi
bmacbmac
  • Locked
  • Question
Help searching within this Json file
Replies
0
Views
75
bmacbmac
bmacbmac

Part and Inventory Search

Sponsor

Back
Top