Tuesday, 6 March 2012

Using MID()

SELECT MID(yourcoloumname,1,5) as yourcoloumname FROM yourtablename




1,5 is the range length

No comments:

Post a Comment