convert to number with two decimals then as varchar 1

[Chumley40]

I need to convert a numeric field to a varchar but don't want more than two decimal points to show. It is part of a case statement.
Right now I have:
When field.value is not null then RTRIM (CAST (field.value as varchar (245)))

How can I change that so that it returns a text number like 1.00 instead of 1.0000?

Thanks!

 

[SQLDenis]

cast to numeric with 2 decimals precision

declare @f numeric(38,23)
select @f = 121.555
select @f,convert(numeric(38,2),@f),convert(varchar(66),convert(numeric(38,2),@f))

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[Chumley40]

Worked like a charm, thanks so much!