Grids, dropdown, sql queries and extra spaces

[eagle]

I have a sql query that combines 2 fields to end up as one, and binds to a
dropdown list in a grid. I want to add spaces into the qry so the fields
look like the are separate. But the drop down list seems to trim any extra
spaces, and it displays any html codes I put in there. Does anyone know how
to do this?
This is what I want displayed in the drop down list, with a significant
amount of space between the date and the currency:

01/01/05 12.00
01/02/05 13.00

This is what I've tried:

select Convert(varchar, datBillDate, 1) + '     ' +
Convert(varchar, curAmountOwed) as ddldisplay from tbl

select Convert(varchar, datBillDate, 1) + '     ' +
Convert(varchar, curAmountOwed) as ddldisplay from tbl

Result: 01/01/05      12.00

select Convert(varchar, datBillDate, 1) + Char(9) + Char(9) + Char(9) +
Char(9) + Convert(varchar, curAmountOwed) as ddldisplay from tbl

Result (displays as just one space): 01/01/05 12.00

I've tried using Char(32) also.

Any other ideas?

[Sagar]

Please try SPACE and see if that works..

"eagle" <eagle@yahoo.com> wrote in message
news:eZPY6e1pFHA.2416@TK2MSFTNGP14.phx.gbl...

>I have a sql query that combines 2 fields to end up as one, and binds to a
> dropdown list in a grid. I want to add spaces into the qry so the fields
> look like the are separate. But the drop down list seems to trim any
> extra spaces, and it displays any html codes I put in there. Does anyone
> know how to do this?
> This is what I want displayed in the drop down list, with a significant
> amount of space between the date and the currency:
>
> 01/01/05 12.00
> 01/02/05 13.00
>
> This is what I've tried:
>
> select Convert(varchar, datBillDate, 1) + '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'
> + Convert(varchar, curAmountOwed) as ddldisplay from tbl
>
> select Convert(varchar, datBillDate, 1) + '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'
> + Convert(varchar, curAmountOwed) as ddldisplay from tbl
>
> Result: 01/01/05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12.00
>
> select Convert(varchar, datBillDate, 1) + Char(9) + Char(9) + Char(9) +
> Char(9) + Convert(varchar, curAmountOwed) as ddldisplay from tbl
>
> Result (displays as just one space): 01/01/05 12.00
>
> I've tried using Char(32) also.
>
> Any other ideas?
>
>
>
>
>

[eagle]

That was a good idea, but it didn't work either.

"Sagar" <mmsagar@hotmail.com> wrote in message
news:uolfzk3pFHA.3884@TK2MSFTNGP10.phx.gbl...

> Please try SPACE and see if that works..
>
> "eagle" <eagle@yahoo.com> wrote in message
> news:eZPY6e1pFHA.2416@TK2MSFTNGP14.phx.gbl...

>>I have a sql query that combines 2 fields to end up as one, and binds to a
>> dropdown list in a grid. I want to add spaces into the qry so the fields
>> look like the are separate. But the drop down list seems to trim any
>> extra spaces, and it displays any html codes I put in there. Does anyone
>> know how to do this?
>> This is what I want displayed in the drop down list, with a significant
>> amount of space between the date and the currency:
>>
>> 01/01/05 12.00
>> 01/02/05 13.00
>>
>> This is what I've tried:
>>
>> select Convert(varchar, datBillDate, 1) +
>> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;' + Convert(varchar, curAmountOwed) as
>> ddldisplay from tbl
>>
>> select Convert(varchar, datBillDate, 1) +
>> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;' + Convert(varchar, curAmountOwed) as
>> ddldisplay from tbl
>>
>> Result: 01/01/05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12.00
>>
>> select Convert(varchar, datBillDate, 1) + Char(9) + Char(9) + Char(9) +
>> Char(9) + Convert(varchar, curAmountOwed) as ddldisplay from tbl
>>
>> Result (displays as just one space): 01/01/05 12.00
>>
>> I've tried using Char(32) also.
>>
>> Any other ideas?
>>
>>
>>
>>
>>

>
>