• what is the datatype of the field containing the decimal point?

    If it's varchar you could:

    declare @mynum varchar(20)

    set @mynum = '10.7333'

    select replace(@mynum,'.','')