SQL Utility Functions

CREATE FUNCTION [dbo]. [Varcharmax2table]    (      @value varchar (MAX),      @separator varchar (255)    ) RETURNS tableasreturn    SELECT  LTRIM (RTRIM ( B.value) value from    (SELECT    CONVERT (XML, ' <v> ' + REPLACE (@value, @separator,                                                     ' </v>< V> ') + ' </v> ') value            a            OUTER APPLY (SELECT    n.v.value ('. ', ' varchar (max) ') value                          from< C14/>a.value.nodes ('/V ') N (v)                        ) b    WHERE   LTRIM (RTRIM (b.value)) <> ' GO

Suppose to query the city, the argument is a string, such as ' Beijing, Shanghai, Guangzhou, Shenzhen '

Select *  from table1 where inch Select  from Mtnoh_aaa_platform.dbo. Varcharmax2table (' Beijing, Shanghai, Guangzhou, Shenzhen ', '))

SQL Utility Functions