Re: Database Queries (gurus - Help needed)

zsan

Try this

UPDATE Table_name
SET name = substr(name,3,len(name))
WHERE name_id = name_id

This length function of the field will take into consideration the varaiable length elements. Please verify the len is the correct function I can not remember whether it is len or length

I hope this helps

Miked

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
Received on Wed Aug 23 1995 - 00:00:00 CEST