Hello all.

I am trying to use if not exists on a db update but am getting 'Invalid parameter binding(s).' errors.

Any ideas?

IF NOT EXISTS
(select mobile_number
FROM tblCustomer
WHERE mobile_number = 'nParam'
AND op_id = 'opParam'
)
BEGIN
INSERT INTO tblCustomer (
mobile_number, op_id
) VALUES (
'nParam',
'opParam'
)
END

Many thanks