Alban Hertroys skrev: > Presumably he wanted col2 like E'%\\\\N%'. > But doesn't \N mean NULL, or would the OP be looking for literal '\N' > strings in his data? Because if he's looking for NULLs it may be better > to query for col2 IS NULL. My guess is that this string was used to signify NULL in the file originally imported into the db. Nis ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings