Posted in October 2012

Learn Regular Expression in 15-Minutes

What are Regular Expressions and Why we should use it ? Regular expressions are used to search, replace ,split  ,match  for substrings (“matches”) in strings. This is done by searching with “patterns” through the string . Where To use Regular Expressions ?Regular Expressions are one of the foundations of the Perl programming language and therefore … Continue reading

SQL string Functions Tutorial (SQL Server 2005 -2012)

Below are all SQL string functions and they are very commonly used according to requirements. i tried to describe them in very easy manner and puts best efforts to make them understandable .1.ASCII function returns the ASCII code value from the leftmost character specified character expression. It takes 1 argument as string/character expression. Example:select ASCII(‘A’) orselect ASCII(‘AD’)    //giving value ASCII value … Continue reading