Hi,
Please can anyone provide an SQL syntax:
To replace selected records in a field based on condition of another field. For example,
Two fields a and b. 'a' field has three records, 1,2,3. b field has x,y and z. I like to replace all records '2' in field a if
field b is x with value 5
Thanks.
Nijojo.