Escaping special character in Teradata

If your table tbl_esc contains the following data,
name
%sdd
asdf
asd%dt


1. Escaping at the first occurrence
SELECT name FROM tbl_esc WHERE name LIKE '@%%' ESCAPE '@'

name
%sdd



2. Escaping at the first and intermediate occurrence
SELECT name FROM tbl_esc WHERE name LIKE '%@%%' ESCAPE '@'

name
%sdd
asd%dt