Re: Database Queries (gurus - Help needed)
From: Tommy Wareing <p0070621_at_brookes.ac.uk>
Date: 1995/08/17
Message-ID: <40utn7$j1e_at_cs3.brookes.ac.uk>#1/1
Date: 1995/08/17
Message-ID: <40utn7$j1e_at_cs3.brookes.ac.uk>#1/1
In article <zsanDDFJ11.6oJ_at_netcom.com>, Zsan says...
>
>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.
RTFM.
select substr(field, 3)
from table.
-- _________________________ __________________________________________ / Tommy Wareing \ / I've been looking for an original sin, \ | p0070621_at_brookes.ac.uk X One with a twist and a bit of a spin | \ 0865-483389 / \ -- Pandora's Box, Jim Steinman / ~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Received on Thu Aug 17 1995 - 00:00:00 CEST