Tuesday, April 10, 2007

CASE STATEMENT IN SQL SERVER

update bladder_data set plant_id =
case
when charindex('M',bladder_barcode,3) > 3 and charindex('M',bladder_barcode,3) < (len(bladder_barcode)-8) then 3 else 4 end
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)