[SQLDownUnder] case statment in UPDATE STATEMENT

[anthony]

How  can i incorporated a Select statement in  Update statement?

 

 

UPDATE tblProducts  SET Price= SELECT CASE Price WHEN 10 THEN 1.1 END

 

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net