Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to create an Update query in BASE SQL

SYNTAX: UPDATE table SET column = Expression [, ...] [WHERE Expression];

UPDATE "tblMainCustInfo" SET "Cell_Phone1_Name" = 'Some text' WHERE "Cell_Phone1_Name" IS NULL

I tried this but NO GO....!!!!

Not sure how to solve this.

FYI: I am super new in SQL; so please be patient with me.

Thanks in Advance.