|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Left Function? |
|
From: |
Harlan |
|
Date: |
3/11/1999 5:24:04 PM |
|
IP: |
206.222.20.2 |
you mean like "select left(cmnOne,len(cmnOne) -1) from tblOne" ect....
I don't know the syntax for sure in SQL but I'm possitive you can do it. In oracle 7 its
"Select substr(cmnOne,startPoss,Len).."
so if you had "hellothere" returned you could
substr(cmnOne,1,5) and get back "hello"
Sorry I don't know the exact syntax in sql, and my sql book is at home, but at least I know you can do it for sure ;)
hth,
Harlan Mott |
Previous Message
Follow Up - Re: Left Function? - John 3/12/1999 9:37:44 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
