What is Character Functions?

Posted by Sabarimahesh under Sql Server on 3/27/2012 | Points: 10 | Views : 2007 | Status : [Member] | Replies : 6
What is Character Functions?

Technical Hr Asked This Question in Interview

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M



Responses

Posted by: Rajni.Shekhar on: 3/27/2012 [Member] Bronze | Points: 25

Up
0
Down
Character Functions are used in oracle.

"functions that takes one or more character as a parameter and return either a character or number value"

for more details:

http://docstore.mik.ua/orelly/oracle/prog2/ch11_01.htm

Thanks,
Rajni Shekhar

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 3/27/2012 [Member] Silver | Points: 25

Up
0
Down

Hi,
Refer to this for all built in functions.
http://www.codeproject.com/Articles/38998/Most-Commonly-Used-Functions-in-SQL-Server-2005-20

Thanks,
Sanjay

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sabarimahesh on: 3/28/2012 [Member] Bronze | Points: 25

Up
0
Down
Sksamantaray

yA SURE

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sabarimahesh on: 3/28/2012 [Member] Bronze | Points: 25

Up
0
Down
Rajni.Shekhar

Ho Good...


Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 6/20/2012 [Member] Bronze | Points: 25

Up
0
Down
SQL Aggregate Functions
SQL aggregate functions return a single value, calculated from values in a column.

AVG() - Returns the average value
COUNT() - Returns the number of rows
FIRST() - Returns the first value
LAST() - Returns the last value
MAX() - Returns the largest value
MIN() - Returns the smallest value
SUM() - Returns the sum

SQL Scalar functions

SQL scalar functions return a single value, based on the input value.


UCASE() - Converts a field to upper case
LCASE() - Converts a field to lower case
MID() - Extract characters from a text field
LEN() - Returns the length of a text field
ROUND() - Rounds a numeric field to the number of decimals specified
NOW() - Returns the current system date and time
FORMAT() - Formats how a field is to be displayed

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response