Forums
This topic is locked
filter recordset
Posted 11 Jun 2001 12:03:41
1
has voted
11 Jun 2001 12:03:41 gianluca jean posted:
What is the sql stantement in UD to filter more fieldsI have used this, but it don't work
SELECT *
FROM Tabella x
WHERE field1 OR field2 OR field3 = 'Search'
Thanks to all
Replies
Replied 11 Jun 2001 17:41:33
11 Jun 2001 17:41:33 Viktor Farcic replied:
SELECT *
FROM Tabella x
WHERE field1 = 'Search' OR field2 = 'Search' OR field3 = 'Search'
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
What is the sql stantement in UD to filter more fields
I have used this, but it don't work
SELECT *
FROM Tabella x
WHERE field1 OR field2 OR field3 = 'Search'
Thanks to all
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
FROM Tabella x
WHERE field1 = 'Search' OR field2 = 'Search' OR field3 = 'Search'
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
What is the sql stantement in UD to filter more fields
I have used this, but it don't work
SELECT *
FROM Tabella x
WHERE field1 OR field2 OR field3 = 'Search'
Thanks to all
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>