Subject | Substring |
---|---|
Author | Jorez A. Nasato |
Post date | 2002-12-04T12:29:10Z |
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))
Thanks!
Jorez
[Non-text portions of this message have been removed]
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))
Thanks!
Jorez
[Non-text portions of this message have been removed]