Hi,

I'm wanting to do a query with a result that includes carriage returns.
Something like:

Select field1 + #13+#10 + field2 as MyResultField
From Mytable

Apparently #13+#10 doesn't work in SQL as listed above, but you can use it
in SQL like:

Sorry, hit the wrong button (CTRL + S instead of CTRL + V) !

I'm wanting to do a query with a result that includes carriage returns.
Something like:

Select field1 + #13+#10 + field2 as MyResultField
From Mytable

Apparently #13+#10 doesn't work in SQL as listed above (because of the field
type), but you can use it
in SQL like the above if the field is a string field. (Just not a blob
field).

The fields above are blob fields, but with 'text'.

I was wondering if there is a way to do the above in a 'blob' field?

Thanks & Regards

Adam.

you can cast the field as char

select cast (field as char(255)) + #13 + #10 as myfield

Robert

"Adam H." <ahairsub4@pleaseREMOVEme.jvxp.com> wrote in message
news:952B26A1-3B96-46DE-BC0C-64A86E1D0C30@news.elevatesoft.com...
> Sorry, hit the wrong button (CTRL + S instead of CTRL + V) !
>
> I'm wanting to do a query with a result that includes carriage returns.
> Something like:
>
> Select field1 + #13+#10 + field2 as MyResultField
> From Mytable
>
> Apparently #13+#10 doesn't work in SQL as listed above (because of the
> field type), but you can use it
> in SQL like the above if the field is a string field. (Just not a blob
> field).
>
> The fields above are blob fields, but with 'text'.
>
> I was wondering if there is a way to do the above in a 'blob' field?
>
> Thanks & Regards
>
> Adam.
>
>

Adam,

<< Select field1 + #13+#10 + field2 as MyResultField From Mytable >>

Just use this variation on Robert's idea:

select cast (field as memo) + #13 + #10 as myfield

--
Tim Young
Elevate Software
www.elevatesoft.com

Mmmmmm very interesting !
I'am using Ehlib grid and it supports wordwrap
I would however like to populate one column
cell with the info from 2 fields.
Column 1 holds the starting price of a horse
Column 2 holds the total staked already on that horse.
In the grid I would like to display the SP above the
currencey like below well sort off but neater
___________
|        5/1       |
| £10,789.00 |
|__________|
|       7/1        |
|  £4,637.00  |
|__________|


How could I do that any grid will do if I dont have
it I will get it.

Thanks Rita


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:1C95DA4B-B2DA-41C9-947B-01659E26DC35@news.elevatesoft.com...
> Adam,
>
> << Select field1 + #13+#10 + field2 as MyResultField From Mytable >>
>
> Just use this variation on Robert's idea:
>
> select cast (field as memo) + #13 + #10 as myfield
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Rita


TMS software have a grid that will do it.

Roy Lambert

Thanks Roy I never thought about them I have
their IW stuff tho maybe I should try their
IWDBadv grid 1st
Rita

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:364FE7F8-9604-40E5-8A78-0AE2891B5DE0@news.elevatesoft.com...
> Rita
>
>
> TMS software have a grid that will do it.
>
> Roy Lambert
>

Hi Rob and Tim,

Thanks for the suggestions!

Cheers

Adam.