Thanks for your help.  I got the answer from another list, and wanted to
update this archive.  Here's the solution:

...

Ed,

If WORKSTATIONNAME can have null values, it may give you trouble.  When you
do your initial SELECT, try this

SELECT
other fields,
ISNULL(WORKSTATIONNAME,'') AS WORKSTATIONNAME
FROM tableName

Then do your Q of Q with the LIKE operator.

Hien

-----Original Message-----
From: Suyer, Ed [PRD Non-J&J]
Sent: Thursday, October 09, 2003 8:06 AM
To: '[EMAIL PROTECTED]'
Subject: RE: QoQ and Like

Nope, I checked that, and CFMX 6.1 does support the LIKE statement for QoQ
....

Any other ideas?


[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to