Very Computer

by **Ibrahim Hamoud** » Thu, 05 Nov 1998 04:00:00

This works in Access
How to translate into transact SQL

Ibrahim Hamouda

by **Tony Rogerso** » Thu, 05 Nov 1998 04:00:00

SELECT Discount = CONVERT( varchar( 2 ), dblDiscount ) + "%"

--
Hope the above helps.

Tony Rogerson MCP, SQL Server MVP
Torver Computer Consultants Ltd.

>This works in Access
>How to translate into transact SQL

>Ibrahim Hamouda

by **Ibrahim Hamoud** » Thu, 05 Nov 1998 04:00:00

Thanks tony
That Really Helped
Ibrahim

>SELECT Discount = CONVERT( varchar( 2 ), dblDiscount ) + "%"

>--
>Hope the above helps.

>Tony Rogerson MCP, SQL Server MVP
>Torver Computer Consultants Ltd.

>>This works in Access
>>How to translate into transact SQL

>>Ibrahim Hamouda

Format([dblDiscount],"@@%")