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>


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

Original text of this message