How to convert comma separated column to single value column - comma separate to value

select distinct value as crimecategory, lu.Description from Investigation iv cross apply string_split(iv.crimecategory,',') Left join Lookup lu on value = lu.LookupID where (CrimeCategory != '' OR CrimeCategory != NULL) AND BranchId=30 

or

 SELECT VALUE FROM string_split('1, 3, 5', ',')

reference:-  https://www.geeksforgeeks.org/how-to-turning-a-comma-separated-string-into-individual-rows-in-sql-server/

Remove blank rows from column in sql select query

Use distinct keyword and null or 'xyz' (blank values)

select distinct value as crimecategory, lu.Description from Investigation iv cross apply string_split(iv.crimecategory,',') Left join Lookup lu on value = lu.LookupID where (CrimeCategory != '' OR CrimeCategory != NULL) AND BranchId=30 

 reference:- https://stackoverflow.com/questions/10912237/sql-select-distinct-rows-and-ignore-row-if-blank

https://stackoverflow.com/questions/30284503/how-to-remove-blank-rows-from-sql-result-set

Select stored procedure- select query to XML

 ALTER PROCEDURE [dbo].[SSP_AllState] --1  

  

  

AS   

BEGIN  

SELECT CAST((SELECT [StateId]  

      ,[StateName]  

      ,[StateNameInLocal]  

      ,[StateCode]  

      ,[IsActive]  

      ,[CreatedBy]  

      ,[CreatedDate]  

      ,[UpdatedBy]  

      ,[UpdatedDate]  

If telerik controls are not working -asp.net

 add script manager

<asp:ScriptManager ID="ScriptManager1" runat="server" AsyncPostBackTimeout="300" EnablePartialRendering="True" EnablePageMethods="true" ScriptMode="Release">

https://docs.telerik.com/devtools/aspnet-ajax/controls/multiselect/getting-started

Telerik multi select - telerik combobox- asp.net

 https://docs.telerik.com/devtools/aspnet-ajax/controls/multiselect/getting-started

https://demos.telerik.com/aspnet-ajax/combobox/examples/functionality/checkboxes/defaultcs.aspx

https://www.telerik.com/forums/multiple-selection-of-radcombobox