Archives of the TeradataForum
Message Posted: Wed, 07 Mar 2012 @ 13:23:05 GMT
<-- Anonymously Posted: Wednesday, March 07, 2012 08:10 -->
The wild card characters for single char and multiple chars are '_' and '%'. In your example there is a '_' which is being treated as a sigle wild card char by Teradata.
So please try as below.. which may help...
SELECT ..... TABLENAME LIKE '%_WORLD' ;
Thanks and Regards
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|