scalar function usage
Posted: Thu Aug 12, 2010 10:33 am
is it possible to use scalar function in the where and order by clause?
If not which one will be the appropriate place to use the function?
eg: select acct-num
where (substr(location-code,6,1)=2)
If not which one will be the appropriate place to use the function?
eg: select acct-num
where (substr(location-code,6,1)=2)