Money conversion

[msalvador]

HI, this is my problem.
I've a table PLU, there are two fields
barcode(varchar(50)),
price(money)

I try to make a search with like condiction but it's doesn't work if price have two or more(four) decimal places.
Because money have always four decimal places.

Ex.

barcode | price |
------------------
1 |150
2 |12.3000
3 |33.33
4 |3



select * from PLU where where cast(RP_ProductPrice as varchar) like '%3'

i'd like to obtain:

barcode | price |
------------------
2 |12.3000
3 |33.3300
4 |3

 

[arrowhouse]

If you want all prices that contain a 3 change your like '%3' to '%3%'

 

[msalvador]

no only the price that finished with 3