How to include '+' symbol in the string
807601Mar 23 2008 — edited Mar 24 2008Dear Experts,
I am using the following query:
strQuery = " INSERT INTO master_table (numeric_id, full_name) values (SELECT CASE WHEN MAX (numeric_id) IS NULL THEN 1 ELSE MAX (numeric_id) + 1 END,'My Name')";*
As an output for the above string the '+' is missing with gives an error as a syntax error of this query.
Any suggestion will be appreciated