01-16-2024 10:31 PM
Hi,
I'm trying to write a query in MV (Spark SQL) which excludes the items ending with "_X"
I understand underscore ("_") is single character wildcard in SQL and should be addressed as '%[_]x' or '%\_x' which will include the Underscore (_). But it seems in Incorta - this is not working properly. After using the below query I can still see items ending with '_x'
select * from table1
where CATALOG_NUMBER not like '%\_x'
or CATALOG_NUMBER not like '%\_X'
Please suggest any other method or if i'm missing anything above?
Thanks,
Nikhil
-nikhil.cr@lkqeurope.com
Solved! Go to Solution.
01-22-2024 02:53 AM
Thank you 🙂 This is working now.