Anonymous user
String case: Difference between revisions
sql pl
m (→with capitalized words: changed the link prose to changestr.rex.) |
(sql pl) |
||
Line 2,300:
print upper(@s)
print lower(@s)</lang>
=={{header|SQL PL}}==
{{works with|Db2 LUW}}
With SQL only:
<lang sql pl>
values upper('alphaBETA');
values lower('alphaBETA');
select upper('alphaBETA') from sysibm.sysdummy1;
</lang>
Output:
<pre>
db2 -t
db2 => values upper('alphaBETA');
1
---------
ALPHABETA
1 record(s) selected.
db2 => values lower('alphaBETA');
1
---------
alphabeta
1 record(s) selected.
db2 => select upper('alphaBETA') from sysibm.sysdummy1;
1
---------
ALPHABETA
1 record(s) selected.
</pre>
=={{header|Standard ML}}==
| |||