Don't you hate when you click the wrong keys on the keyboard :) No problem!
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:52 PM To: CF-Community Subject: RE: using left in SQL statement Let me stand in the intersection of Commonwealth and Beach so I can get ran over by a truck... This entire time I thought I was using "left", but when I looked a little closer, I was using "ltrim"... Typed it right in the email, but not in SQL... Thanks Shawn :) At 02:33 PM 11/27/2002 -0800, you wrote: >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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
