Raymond
Teradata SQL LIKE: Contains, Starts With, Ends With Functions
insights Stats
warning Please login first to view stats information.
toc Table of contents
This page shows how to use LIKE in Teradata to check whether a string column contains, starts with or ends with certain characters.
All the code snippets are using string literal and you can replace them with your table/view column name if you want to apply them in your queries.
Starts with a string
We can use % to match a
select case when 'Kontext.tech' LIKE 'Kontext%' then 1 else 0 end
The above query returns 1 as the string literal starts with Kontext.
Ends with a string
select case when 'Kontext.tech' LIKE '%tech' then 1 else 0 end
The above query returns 1 too as the string literal does end with tech.
Contains a string
select case when 'Kontext.tech' LIKE '%text%' then 1 else 0 end
This query also returns 1 as the string literal has that sub string inside it.
You can also use other functions like INDEX or POSITION.
INDEX function
select case when INDEX('Kontext.tech', 'text')>0 then 1 else 0 end
The function will return 0 if the search string doesn't exist.
POSITION function
sel position('text' in 'Kontext.tech' )
The function will return 0 if the search string doesn't exist.
info Last modified by Administrator 4 years ago
copyright
This page is subject to Site terms.
comment Comments
No comments yet.