[GENERAL] SELECT question (splitting a field)

[Madison Kelly]

Hi all,

  Hopefully a quick question...
  Why does:

nmc=> SELECT 'Y' AS local FROM domains WHERE dom_name='test.com';
 local
-------
 Y
(1 row)

  Work but:

nmc=> SELECT 'Y' AS local FROM domains WHERE '@'||dom_name IN 
('[EMAIL PROTECTED]');
 local
-------
(0 rows)

  Not work?

  I am sure I am missing something simple. :)

Thanks!!

Madi

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly