HP3000-L Archives

December 1999, Week 2

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Select part of a column with SQL?
From:
[log in to unmask][log in to unmask]
Reply To:
[log in to unmask]
Date:
Thu, 9 Dec 1999 20:20:27 GMT
Content-Type:
text/plain
Parts/Attachments:
text/plain (10 lines) 
Can someone tell me the syntax for selecting part of a column using
either IMAGESQL or ISQL? I need to create a view table that has a column
that is the first 12 bytes of a column in an existing table. I have
tried things like SELECT NEW_COL=SUB(OLDCOL,1,12) but that doesn't work.
Any ideas people?


Sent via Deja.com http://www.deja.com/
Before you buy.

ATOM RSS1 RSS2