Click here to check my latest exciting videos on youtube
Search Mallstuffs

Flag Counter
Spirituality, Knowledge and Entertainment


Locations of visitors to this page


Latest Articles


Move to top
Different string functions in SQL-Part 2
Posted By Sarin on Mar 17, 2012     RSS Feeds     Latest Hinduism news
2534 Views

PATINDEX: 
Searches for a pattern of characters within a string. This is similar to char index except that it also allows usage of wildcards


  
  
REPLACE: 
For the string specified in the first parameter, all instances of the string specified in the second parameter will be replaced by the string specified in the third parameter.  
This function can replace all occurrences of one character or substring


Replace space by underscore

  
REPLICATE: 
Replicate  the same string number of times specified in the second parameter.

  
REVERSE: 
Takes the string input, and display the string in the reverse order .

  
RIGHT ():
  Starts at the right-most character and counts to the left, returning the specified number of characters i.e. Returns a number of characters from the right-hand side of a string
  
SOUNDEX: 
check how similarly sounding two tested strings can be



SPACE:
Returns a number of spaces as specified in the parameter
  
STR () Function: 
Converts a numeric value to a string. String length will be equal to the number specified by the second parameter. Decimal point will be at the position (taken from right) specified by the third parameter

  
Specifying an overall length greater than the length of the value, decimal point, and the decimal value, the result will be left-padded with spaces


  
UPPER
Reverse of lower, translates all characters within the string to upper case


  
STUFF (): 
Replace a portion of a string with another string at the location specified in the second parameter.
String represented in the fourth parameter will replace the part of the original string by removing the number of character specified by the third parameter.
  
STUFF(original_string, start_point, length, string_to_insert)

  
UNICODE: 
Returns the integer Unicode value of a single leftmost character in a string

  
SUBSTRING (): 
Starts at a position (parameter 2) and counts characters (parameter 3) to the right, thus returning a substring of the original string.

Note: Images used on this website are either a production of Bhaktivedanta Book Trust(https://www.krishna.com), Iskcon Foundation or were found in google search under "Free to use and share". If any of the images presented here violates copyright issues or infringes anyone copyright or are not under "Fair use", then please bring it to our notice. Read Disclaimer for more.

Share this to your friends. One of your friend is waiting for your share.
Related Articles
Different types of alter table command to change database schema
Need and advantages of using computed columns
Different string functions in SQL-Part 1
Playing with HTML using Jquery
Commonly used string operation in SQL
Different types of File Write Operations
Create property class of database table
Advanced Strings Format for numbers
SQL-Removing numbers in a string
Advanced Datetime Format for string

Post Comment