24 Oct 2008 at 08:55 #1 Lead_Head Lead_Head Soldato Joined 26 Jan 2003 Posts 3,704 Location Nottm I'm selecting from a column that either has to be NULL or 'FRED' How do I write this in the predication (where clause)? e.g. WHERE columnA IS NULL OR 'FRED'
I'm selecting from a column that either has to be NULL or 'FRED' How do I write this in the predication (where clause)? e.g. WHERE columnA IS NULL OR 'FRED'
24 Oct 2008 at 09:19 #3 Lead_Head Lead_Head Soldato OP Joined 26 Jan 2003 Posts 3,704 Location Nottm Gah! I tried that.... But, it didn't work because I had an 'AND' before it, when I didn't need it as it was the first where clause, damn copy and paste! Doh!
Gah! I tried that.... But, it didn't work because I had an 'AND' before it, when I didn't need it as it was the first where clause, damn copy and paste! Doh!
