RE: SQL column size

["Stone, Brad V (TC)" <bvstone@xxxxxxxxxxxxxx>]

Try SUBSTR(field,start,length)

> -----Original Message-----
> From: Goodbar, Loyd (AFS-Water Valley) 
> [mailto:LGoodbar@afs.bwauto.com]
> Sent: Tuesday, October 24, 2000 3:34 PM
> To: MIDRANGE-L@midrange.com
> Subject: SQL column size
> 
> 
> I'm using a utility like Midrange Computing's RUNSQLSTM 
> utility. I can run
> SELECTs just fine. However, if I have a field that is 20 char 
> long and I
> only want to show the first 10 characters in the output, is 
> there an easy
> way to do this in straight SQL, or do I need to convert to a 
> QMQRY? I do not
> have the SQL developer product.
> 
> Thanks,
> Loyd
> 
> --
> Loyd Goodbar
> Programmer/Analyst
> BorgWarner Incorporated
> Air/Fluid Systems, Water Valley, MS
> 
> 
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: 
> david@midrange.com
> +---
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---