> Not likely it's null but I went ahead & tried it using VAL & still get the > same error. > > Any other suggestions? > > This site is using CF5 if that helps - database is SQL 2000 > > Thanks, > Donna
Yep...1st thing you do when you get an error like that is CFDUMP all values involved and go from there. We can theorize what it MAY be all day, but until we know what the actual values are it may be tough to say ;-) As it was originally mentioned...NULL could be an issue, so at the very least your use of VAL or checking the trimmed length AND it's value should have been there from the start. So now we need to know what the values involved are and try and assess from there Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249520 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4