I am doing a simple sql select statement:

output to custfax.dat without headings
select t_cuno, t_nama, t_tefx from custtable

I need to use this in a subsequent unix script and would like to put a delimiter in between the fields so I can just awk them out.

Is there a way to do this?

[Ok. I found the answer to this... I'm using ":"
however
Now the output is on seperate lines because the name field is so large.

Is there a way for me to get the first 15 characters of a 30 character field?

tanks!