Passing a varchar full of comma delimited values to a SQL Server IN function

by

Of course if you’re lazy like me, you could just do this:

Declare @Ids varchar(50) Set @Ids=",1,2,3,5,4,6,7,98,234,"

Select * from sometable
 where Charindex(','+cast(tableid as varchar(8000))+',', @Ids) > 0

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Get top 1 row of each group
  3. How to return only the Date from a SQL Server DateTime datatype
  4. DateTime2 vs DateTime in SQL Server
  5. How to select all records from one table that do not exist in another table?
  6. SET versus SELECT when assigning variables?
  7. How do you list the primary key of a SQL Server table?
  8. Generate Dates between date ranges
  9. Calculating distance between two points (Latitude, Longitude)
  10. Add Foreign Key relationship between two Databases
  11. How to print VARCHAR(MAX) using Print Statement?
  12. How to assign an exec result to a sql variable?
  13. Query error with ambiguous column name in SQL
  14. Why (and how) to split column using master..spt_values?
  15. Splitting delimited values in a SQL column into multiple rows
  16. What does =* mean?
  17. SQL: parse the first, middle and last name from a fullname field
  18. varbinary to string on SQL Server
  19. Scope of temporary tables in SQL Server
  20. How can I include null values in a MIN or MAX?
  21. SQL Server 2005 ROW_NUMBER() without ORDER BY
  22. Can an INNER JOIN offer better performance than EXISTS
  23. Find the real column name of an alias used in a view?
  24. Stored procedure that exports data into csv files only exports to one file
  25. Get Start and End Date from Week Number SQL Server
  26. Get the last day of the month in SQL
  27. How to create a pivot query in sql server without aggregate function
  28. SQL take just the numeric values from a varchar
  29. COALESCE Function in TSQL
  30. Convert bigint to datetime

Leave a Comment