Search code examples
sqloracle-databasesql-like

Using like depending on string length


I have to filter a column where data I take from the column can not look like '66******1' or '66*******1'. So how do I use LIKE with different string length?


Solution

  • why should we complicate it

    where  column not like '66_______1' or column not like  '66______1'