I have one field as LONGDESC.
I want to output as:
1st 5 character of longdesc in 1st line
2nd 5 character i.e 6-10 in 2nd line
3rd 5 character i.e 11-15 in 3rd line
so on till we have any charachter left in LONGDESC field.
Can anyone please suggest some query in SQL.
Thanks In Advance,