• there must be more to the story;

    this works without an issue at all:

    With MyCTE (val)

    AS

    (

    SELECT '.7' UNION ALL

    SELECT '2' UNION ALL

    SELECT '1.3'

    )

    SELECT *,convert(decimal(3,1),val) FROM MyCTE

    could it be that you have data that is larger than 999.9 (so it won't fit in a decimal(3,1), or something that has more precision than 1 decimal place?( ie 333.14?)

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!