|
|
|
|
|
| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
