@jcelko: 5 post before your sample is solution given by Leszek that is working the same way...

Hello, so below two more generic solutions based on tally table. The first in pure sql, second with a little xml support. Solutions base on normalisation (converting to decimal) and comparing (text or float). Both solutions are single queries.

                        



    

        

            
        
        

            Madhivanan JR
            
            
            

            

                
                    3
                    · 
                        39% · 
                            12419
                        
            
            
        
    


                    

Hello, not happy with data like below

 
set @s= '2.202 3.0 31' 

returns:

2.2020 30 4.0000	2.202 3.0 31
2.202000 30 4.0000	2.202 3.0 31

and should return nothing

...

Hello, another approuch using xml (splitting numbers, normalizing and creating key from them - those action perform in searched string and in the table. Next seeking prepared key in the table) regards Zibi

;with cte01...
                        

Hello, next approuch regards Zbigniew

select [sum_of_digits]=cast(cast(
                                     cast(replicate('',len(@i))+''+cast(@i as varchar)+'' as xml).query(
                           ...
                        

Hello, another xml approuch regards Zbigniew

declare @i int, @sql varchar(8000)
set @i=798273

select [sum_of_digits]=cast(
                        cast( 
                              cast(''+cast(@i as varchar...
                        

Hello, this below is proof of such errors

select [sum_of_digits]=
       cast(replace(cast(cast(
            replace(
            replace(
            replace(
            replace(
            replace(
            ...
                        

Method 4 : Using xml (without variables)

select [sum_of_digits]=
       cast(cast(cast(
            replace(
            replace(
            replace(
            replace(
            replace(
...