Re: Database Queries (gurus - Help needed)

Zsandra,
Do you just want a query(read-only), or do you want to update the database with the substringed values? Please be more specific !!!!!

In either case RTFM.

If you DO want to update the database instead of just reading the substringed value try:

update table.name set field_name = substr(field_name,3,20);

Karen Evans
****** My opinions are mine and not my absentee employers' opinion. ;-)  

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 Thu Aug 17 1995 - 00:00:00 CEST