Hey Jacob, Yeah you can use left for that type of return.
I just tested it out and it works fine. Shawn Regan pacifictechnologysolutions 15530-B Rockfield Blvd. Suite 4 Irvine, CA 92618 949.830.1623 w w w . p t s 1 . c o m -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 2:03 PM To: CF-Community Subject: using left in SQL statement Can I do something like this in SQL: select number, item, title from table where number = left(12345, 2) I want to pull just the left 2 numbers from 12345. This will be a variable. But always a number. And using no CF either... TIA Jacob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
