We help IT Professionals succeed at work.

sql format

bhsdba50 used Ask the Experts™
how to create a view that must have defined field lengths
1-3      - 11  - 23  -    31       -  40                -       52 -              66     - 75               -                131

rec_no |  Store_Num |  Invoice_num | Cust_Name |  etc

I have to create a load file that's not comma delimited

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Analyst Assistant
Are all these fields text?

If they are you can use CAST to return fixed length strings from them.

SELECT CAST (rec_no As char(3), CAST (Store_Num As char(11), CAST(Invoice_num as char(23) ... and so on.

If any fields aren't text this might work for them too but they might need to be converted to text first, not too sure about that.