Re: FORM: function in where clause?
From: Craig Kasold <cdg_at_ix.netcom.com>
Date: 2 Feb 1995 13:10:16 GMT
Message-ID: <3gqljo$kde_at_ixnews1.ix.netcom.com>
Date: 2 Feb 1995 13:10:16 GMT
Message-ID: <3gqljo$kde_at_ixnews1.ix.netcom.com>
In <kenho.210.2F278E03_at_hk.super.net> kenho_at_hk.super.net (Kenneth Ho) writes:
>
>In article <3g6qml$2k9_at_debbie.cc.nctu.edu.tw> chiu_at_cc.nctu.edu.tw ()
writes:
>
>>Hi,
>> In SQL FORM, can I declare a function and put it into where clause
for
>>making decision? If yes, how can I do it?
>> For example,
>> Select * from A_Table where make_decision_func(A_Col) = 'Y';
>>Thanks!
>>Keny Chiu
Ken,
Yes.
Select * from a where substr(field1,1,1) = 'Y'
or (even deeper)
Select * from a where substr(field1,1,1) = (select substr(field2,1,1)
from b where b.field3 = 'G')
Craig
Received on Thu Feb 02 1995 - 14:10:16 CET