STRCONV() Function



Syntax:

STRCONV(parameter, converstion type)


What does it do?

The parameter in the form of a string will be changed to a different letter case depending upon which conversion type as a number is entered. There are a few types of conversions, however the three most popular are Upper Case, lower Case and Proper Case. The proper case conversion will make the first letter a capital following every space.


Example: Upper Case

SELECT STRCONV(FirstName, 1) AS FirstName
FROM Customers
WHERE CustomerID = 1;


Results:

FirstName
JOHN

Example: Lower Case

SELECT STRCONV(FirstName, 2) AS FirstName
FROM Customers
WHERE CustomerID = 1;


Results:

FirstName
john

Example: Proper Case

SELECT STRCONV(FullName, 3) AS FullName
FROM Customers
WHERE CustomerID = 1;


Results:

FullName
John Black
HTML 5 Badge