RE: FIND_IN_SET question

2006-11-27 Thread Jerry Schwartz
Is this one of those places where a HAVING clause is needed? ... HAVING YESNO = 0 Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Lars Schwarz [mailto:[EMAIL PROTECTED] > Sen

Re: FIND_IN_SET question

2006-11-26 Thread Visolve DB Team
Hi, Hope, a string constant can be searched against a column; Most of the string function including find_in_set, allows us to display only the table values and not the string constants passed. Try it with 2 tables; or some userdefined functions. Thanks ViSolve DB Team. - Original Message