Teradata SQL LIKE: Contains, Starts With, Ends With Functions

visibility 3,880 comment 0 access_time 2y languageEnglish

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 2y copyright This page is subject to Site terms.
Related series

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Tags
More from Kontext
visibility 14,820
thumb_up 0
access_time 2y
visibility 57
thumb_up 0
access_time 8m
visibility 1,298
thumb_up 2
access_time 3y