Skip to Content
0
Former Member
Sep 22, 2014 at 04:58 AM

How to select UDF s?

21 Views

Dear Sirs

in query I want to SELECT values in field C in case of: field A is not null, field B is not null; field A = '', field B = ''; field A is not null, field B = ''; field A= '', field B is not null.

But i want to do the query shorter

But when Iuse comma the system writes error? ( SELECT * FROM [dbo].[@CATALOG] T0 WHERE ( (select $[OITM.$U_Producer.0]) = T0.[U_BRAND]) , ((select $[OITM.$U_Model.0]) = T0.[U_MODEL])

if to write 'and' instead of comma between parts then all ok.

How to solve the problem?