SQL - how to shift decimal point

[RichardTisdall]

I am trying to compare product prices in two separate tables. The price in one table is data type real, 4 and in the other is smallmoney ,4. My prices are displayed like this.

(Real) (Smallmoney)
PriceSupp CPDPrice
930300.0 93.0300

Can anyone suggest how I can do some sort of conversion to be able to do the comparison.

I thought I could convert both to decimal or numeric bur this does not work. If I try to convert real to small money I get an overflow and if I convert small money to real the value changes to 93.0299. I suspect this causes further issues.

Any help greatly appreciated.

 

[ESquared]

Oh my. I wrote then instead of than. Blush!

 

[donutman]

Oh, your right again...I see you're mistake. Don't worry about it, your older today then you were yesterday. Pretty soon you'll be as senile as I.
-Karl
PS - I think I'll start tormenting you intentionally instead of just accidentally...and you won't know which is which!

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]