At 09:29 AM 04-12-02 -0300, you wrote:

>Hello!
>I'm a new member, and I have a problem.
>
>I have a table with a column NAME VARCHAR(90), and I need do a query tha
>returns this column as VARCHAR(70), I need to use something like
>SUBSTRING, but I don't know how to do.
>
>eg.:
>select name from table ( this query have to return the column as varchar(70))

SELECT SUBSTRING(NAME 1 FOR 70) AS NAME70

heLen