Upsized how to duplicate clng in query.

[markphsd]

Now that I upsized I can't use my query that had the clng function. I looked up on the microsoft site but didn't find a soltuion. How would I emmulate clng?

CLng((dbo.tblProductOrderDetails.Quantity * dbo.tblProductOrderDetails.UnitPrice) * (1 - dbo.tblProductOrderDetails.Discount) * 100) / 100 AS LineTotal

Mark P.

Bleh

 

[chrissie1]

if i am correct clng is character to long then try the convert function you can find the syntax in the sql-server books online wich can be downloaded at microsoft if you do not already have them

Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong