"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?
>
>
>
>
>

"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?
>>
>>
>>
>>
>>
>
>