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:
Example: Lower Case
SELECT STRCONV(FirstName,
2) AS FirstName
FROM Customers
WHERE CustomerID = 1;
Results:
Example: Proper Case
SELECT STRCONV(FullName,
3) AS FullName
FROM Customers
WHERE CustomerID = 1;
Results: