Hi,
I encountered problem in executing the below SQL statement :
select property_no, road_name, postal_code
from usr_prop_info
where substr(postal_code,1,length(a.postal_code)) in (select a.postal_code
from road_info a where district_no = '#form.hdb_estate#')
Apparently, my ROAD_INFO.POSTAL_CODE is either in 2-digit or 3-digit number
but my USR_PROP_INFO.POSTAL_CODE is in 6-digit number.
I'm trying to do a substr() but its length is determined by the length of
the postal_code in ROAD_INFO.
How do I able to achieve that ?
Thanks.
Roger
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]