SQL String Functions

SQL String Functions

Sql string function is a built-in string function.
It perform an operation on a string input value and return a string or numeric value.
Below is All built-in Sql string function :ASCII, NCHAR, SOUNDEX, CHAR, PATINDEX, SPACE, CHARINDEX, REPLACE, STR, DIFFERENCE, QUOTENAME, STUFF, LEFT, REPLICATE, SUBSTRING, LEN, REVERSE, UNICODE, LOWER, RIGHT, UPPER, LTRIM, RTRIM


Example SQL String Function - ASCII
- Returns the ASCII code value of a keyboard button and the rest etc (@,R,9,*) .
Syntax - ASCII ( character)SELECT ASCII('a') -- Value = 97
SELECT ASCII('b') -- Value = 98
SELECT ASCII('c') -- Value = 99
SELECT ASCII('A') -- Value = 65
SELECT ASCII('B') -- Value = 66
SELECT ASCII('C') -- Value = 67
SELECT ASCII('1') -- Value = 49
SELECT ASCII('2') -- Value = 50
SELECT ASCII('3') -- Value = 51
SELECT ASCII('4') -- Value = 52
SELECT ASCII('5') -- Value = 53

SQL SERVER – Convert Text to Numbers (Integer) – CAST and CONVERT

How to convert text to integer in SQL?
If table column is VARCHAR and has all the numeric values in it, it can be retrieved as Integer using CAST or CONVERT function.

How to use CAST or CONVERT?

SELECT CAST(YourVarcharCol AS INT) FROM Table
SELECT CONVERT(INT, YourVarcharCol) FROM Table

Will CAST or CONVERT thrown an error when column values converted from alpha-numeric characters to numeric?
YES.

Will CAST or CONVERT retrieve only numbers when column values converted from alpha-numeric characters to numeric?
NO.

مجھے لکھنے کی خواہش ہے

مجھے لکھنے کی خواہش ہے ۔۔۔

مگر لکھا نہیں جاتا
میرے الفاظ دل کی آہنی دیوار سے سر پھوڑتے ہیں
اور انہیں اظہار کا رستہ نہیں ملتا
میری آنکھیں جنھیں دِل میں چھپے جذبات کو اشکوں کی بولی میں
بتا دینے پہ قدرت تھی
وہ اب کچھ بھی نہیں کہتیں

میرے یہ لب !
جو دل کی ان کہی باتوں کو کہنے سے نہ ڈرتے تھے
وہ لب کچھ بھی نہیں کہتے
میرے یہ اُنگلیاں !
جو دل میں چُھپے جذبات کو اظہار کا رستہ بتاتی تھیں
وہ اب کچھ بھی نہیں لکھتیں

میری آنکھیں، یہ لب، یہ اُنگلیاں مجھ سے کہتے ہیں
کہ اب جذبات کو اظہار کا رستہ نہیں دینا
کہ یہ منہ زور ہوتے ہیں
فقط رستے کے ملنے سے
انہیں منزل تلک جانے کی حاجت ہی نہیں رہتی

نئے رستے پہ جاتے ہیں
نئی راہیں بناتے ہیں
مگر پھر واپسی کے سب نشاں یہ بھول جاتے ہیں
انہیں رستہ نہیں دینا
انہیں تم دِل میں رہنے دو !
وگرنہ خوں رُلائیں گے
انہیں رستہ نہیں دینا
انہیں تم دِل میں رہنے دو !
مجھے لکھنے کی خواہش ہے
مگر لکھا نہیں جاتا

Who Do You Think You Are?

Cascada- Who Do You Think You Are? lyrics

Why can I still believe in tomorrow,
when all I have tried was just in vain (just in vain)
Is it worth the fight I couldn't start believing that those feelings
who died could face the pain (could face the pain)

I don't need no diamond rings, alibis no more.

(chorus):

Who do you think you are
cuz once again you broke my heart
I know that love went just too far
its hard to catch a falling star
but now I finally realize, you're a brown eyed angel in disguise
just one step too far so tell me honestly
who do you think you are
(who do you think you are, who do you think you are)


you and I were on our way together
but this life passed by, these days are gone (these days are gone)
all the tears I've cried they taught me nothing lasts forever
I been blind for just too long

cuz I don't need no diamond rings, alibis no more.

(chorus):
Who do you think you are
cuz once again you broke my heart
I know that love went just to far
its hard to catch a falling star
but now I finally realize, you�re a brown eyed angel in disguise
just one step too far so tell me honestly
who do you think you are (who do you think you are)

Listen To Your Heart...

Listen To Your Heart - Cascada (with lyrics)

Can't Stop The Rain

I Can't Stop The Rain lyrics

How, how am I supposed to feel
When everything surrounding me
Is nothing but a fake disguise
I don't know,
I don't know where I belong
It's time for me to carry on
I'll say goodbye

I can't stop the rain from fallin'
I'm drownin in these tears I cry
Since you left without a warning
I face the dawn with sleepless eyes
No I can't go on
When clouds are pushin' down on me, boy
I can't stop, I can't stop the rain
From fallin

So, tell me where I went wrong
I'm stuck inside a dream long gone
It's hard to reveal the truth
Your love,
Is nothing but a bitter taste
It's better if I walk away,
Away from you

I can't stop the rain from fallin'
Im drownin in these tears I cry
Since you left without a warning
I face the dawn with sleepless eyes
No I can't go on
When clouds are pushin' down on me, boy
I can't stop, I can't stop the rain
From fallin



Cascada - Can't Stop The Rain Lyrics

Sorry, You can put the blame on me!

i wanted you.

Come Around .....

when you say nothing at all

It�s amazing how you can speak right to my heart
Without saying a word you can light up the dark
Try as I may I could never explain
What I hear when you don�t say a thing

The smile on your face lets me know that you need me
There�s a truth in your eyes sayin� you�ll never leave me
The touch of your hand says you�ll catch me if ever I fall
You say it best when you say nothing at all

All day long I can hear people talking out loud
But when you hold me near, you drown out the crowd
Old mr. webster could never define
What�s being said between your heart and mine

The smile on your face lets me know that you need me
There�s a truth in your eyes sayin� you�ll never leave me
The touch of your hand says you�ll catch me if ever I fall
You say it best when you say nothing at all

The smile on your face lets me know that you need me
There�s a truth in your eyes sayin� you�ll never leave me
The touch of your hand says you�ll catch me if ever I fall
You say it best when you say nothing at all