Re: Database Queries (gurus - Help needed)
From: Kevin P. Fleming <kpfhome_at_primenet.com>
Date: 1995/08/16
Message-ID: <40u72p$fca_at_nnrp3.primenet.com>#1/1
Date: 1995/08/16
Message-ID: <40u72p$fca_at_nnrp3.primenet.com>#1/1
In article <zsanDDFJ11.6oJ_at_netcom.com>, zsan_at_netcom.com (Zsan) wrote:
>Could someone help me with a sql database query?
>
>To present a simplified version of the problem, I want to be able to
>do a query to delete the first 2 characters of a field.
>
>Example:
>
>Name
>----
>joseph
>ingrid
>jose
>
>
>then after the query, the result would be:
>
>Name:
>---
>seph
>grid
>se
>
>Any help would be appreciated! (I don't want to do this manually by hand.. :)
)
>
>Zsandra
Use
SELECT SUBSTR(Name,3) FROM TABLE ....
Kevin Fleming, Reliable Networx, Inc.
Phoenix, AZ
Internet: kpfhome_at_primenet.com
"Please, don't change colors while I'm talking to you." Received on Wed Aug 16 1995 - 00:00:00 CEST