I'm trying to do a query where I have data in two different formats...
SELECT Customer, TransNumber, Date
FROM test.Header
Where Customer = "#session.customer#"
The problem I have is that the value of #session.customer# contains the
customer number (260) with no leading characters while the test.header
Customer field comes back with leading 000 characters (000260). If I hard
code it as "WHERE Customer = "000260" it works. My guess is that I need to
do something to pad session.customer with leading zeros up the the length of
the Customer field (which is 6 characters). I can't find a manipulation
function that does this... any ideas?
Thanks!
John
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
