Posted by Jose on 03/21/06 02:18

Hi All,

Sorry if this seems incredibly basic but what is the syntax to solve
this query. I have a table (ENC_UserDefinedData) with 4 columns, ID,
UserID, UserDefinedField and Value. I want to select all the UserIDs
that match this criteria:

[ENC_UserDefinedData].[UserDefinedField] = 8
AND
[ENC_UserDefinedData].[Value] LIKE '%Picasso%'

AND

[ENC_UserDefinedData].[UserDefinedField] = 9
AND
[ENC_UserDefinedData].[Value] = '48'

Thanks in advance,

Jose

• Next in forum: Re: T-SQL Problem
• Prev in forum: Re: add a column specified location in Table..
• Thread view: T-SQL Problem

[Reply to this message]