skip to main
|
skip to sidebar
Home
|
Sign in
Saturday, June 6
Example for LCASE() Function in SQL
LCASE()
- Converts a field to lower case
Syntax : SELECT LCASE(column_name) FROM table_name
Example: SELECT LCASE(Stu_Name) FROM students
0 comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Latest News
Loading...
NSE Nifty Stock Exchange Live Updates
Venkat
Hi Friends,
All Queries & FAQ’s in this blog are real time examples/requirements faced by me.
I think these are help full for developers & beginners.
If you have any queries or advices please
E-mail Me!
Cheers,
Venkat.
View my complete profile
SQL Archive
►
2010
(7)
►
April
(7)
►
Apr 17
(7)
What is Database Architecture ?
What is Physical Data Base ?
What is the role of msdb database?
What is the role of master database?
What are the benefits of Normalization?
What are the disadvantages of Normalization?
Basics queries with examples
▼
2009
(131)
►
November
(2)
►
Nov 12
(1)
How to resolve javascript:false errors ?
►
Nov 07
(1)
How to use rel="canonical" tag and what is the use...
►
October
(2)
►
Oct 28
(1)
List of RUN Commands?
►
Oct 23
(1)
URL ESCAPE CODES (OR) URL ENCODED VALUES
►
July
(6)
►
Jul 13
(6)
Top N data
General Examples
General Examples
How to use INTO, CHARINDEX, SUBSTRING, OPENDATASOU...
How to replace perticular data in a field?
BCP Commands
▼
June
(46)
▼
Jun 06
(35)
How to run sql jobs from command prompt?
Example for CONVERT() Function in SQL
Example for DATEDIFF() Function in SQL
Example for DATEADD() Function in SQL
Example for DATEPART() Function in SQL
Example for GETDATE() Function in SQL
Example for FORMAT() Function in SQL
Example for NOW() Function in SQL
Example for ROUND() Function in SQL
Example for LEN() Function in SQL
Example for LEN() Function in SQL
Example for MID() Function in SQL
Example for LCASE() Function in SQL
Example for UCASE() Function in SQL
Example for SUM() Function in SQL
Example for MIN() Function in SQL
Example for MAX() Function in SQL
Example for LAST() Function in SQL
Example for FIRST() Function in SQL
Example for COUNT() Function in SQL
Example for AVG() Function in SQL ?
What are the Date Functions in SQL
What are the Scalar Functions in SQL
What are the Aggregate Functions in SQL
What are the functions in SQL Server?
What are the difference between DDL, DML and DCL c...
TCL Commands in SqlServer
DCL Commands in SqlServer
DML Commands in SqlServer
DDL Commands in SqlServer
How to manipulate queries on two different databas...
How to disable foreign keys on a DataBase?
How to Disable Foreign key?
How to Disable Foreign key on a Table?
What is SQL Server and what we can do using SQL Se...
►
Jun 05
(11)
►
May
(12)
►
May 24
(6)
►
May 23
(1)
►
May 19
(5)
►
April
(10)
►
Apr 18
(3)
►
Apr 16
(4)
►
Apr 15
(3)
►
March
(53)
►
Mar 18
(3)
►
Mar 17
(5)
►
Mar 16
(41)
►
Mar 15
(3)
►
Mar 14
(1)
Labels
FAQ's
(105)
General
(54)
Interview Questions
(36)
MyQueries
(3)
Q.A Tips and Tricks
(9)
queries
(20)
RUN Commands
(1)
SEO
(2)
SQL Functions
(24)
SQLServer Videos
Loading...
My Favorite Links
SqlAuthority
0 comments:
Post a Comment