Posted by SQL Enthusiast
Article by our editor
CHARINDEX provides an easy way to search for the first occurrence of a string in another string. By reversing the order of the string it can also provide a straightforward way of finding the last occurrence of a string. This can be used in conjunction with the RIGHT function to extract the part of a string that is after the last occurrence of a given delimiter
Comments • Read full article »
This SQL script creates a comma separated list of all columns in a table. This can be useful for creating SQL INSERT and SELECT statements etc.
Comments (2) • Read full article »
More SQL questions »
© 2010 - 2016. All Rights Reserved. Design by