RosettaCodeData/Task/String-comparison/DuckDB/string-comparison.duckdb

11 lines
231 B
Plaintext

select s,
t,
s == t,
s != t,
s < t,
s > t,
upper(s) = upper(uppers) as "case insenstive",
'2' < '1e10',
s ilike uppers
from (select 'abc' as s, 'def' as t, 'ABC' as uppers );