Advanced Search

Return to Snippet

Revision: 65259
at November 12, 2013 02:55 by ironcrema
Initial Code 
SELECT 
    CASE 
        WHEN CHARINDEX('(', Val) > 0 THEN 
            RTRIM(SUBSTRING(val,1, CHARINDEX('(', Val) - 1))
        ELSE Val
    END
FROM @Data
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Extrae subcadena de cadena separado por caracter

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Extraer cadena segun caracter

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, server

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL