H
hyperactifone
Guest
I am trying to code an if statement into a select query. the code for which is below : The code works but not correctly. Some of the fields in FN2 are blank so the query leaves the merged field empty too. This is NOT the desired effect. I know i need to put an IF statement in but everything I try seems to make it refuse to run and throw up errors.
Please help.
Code :
------
SELECT [FN1]+" "+[FN2] AS Expr1
FROM centres AS centname;
Thanks in Advance
Please help.
Code :
------
SELECT [FN1]+" "+[FN2] AS Expr1
FROM centres AS centname;
Thanks in Advance