Archives of the TeradataForum
Message Posted: Mon, 22 Nov 2004 @ 20:34:40 GMT
<-- Anonymously Posted: Monday, November 22, 2004 15:14 -->
I am trying to work with LIKE operator to find out all the columns in the data base that end with "_ID". I know for sure that there are lot of column names that end with _ID (Ex: XXXX_ID). My queries where clause looks like
WHERE columnname like '%_ID'
which is giving zero rows. But when I rewrite the query as
WHERE columnname like '%_ID%'
Then it is giving the proper result.
Can any one suggest me why it is not working when the like operator used LIKE '%_ID' ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|