Query-Select Item Code ending in 'NI'

[Former Member]

How do I select an Item Code ending in 'NI'?

[Former Member · Accepted solution]

SELECT * FROM OITM T0 WHERE REVERSE(T0.ItemCode) LIKE 'IN%'

[Former Member · Accepted solution]

Hey Thomas!

Hope all is good there!

Thanks for your help - like the "old" days!

[Former Member · Accepted solution]

Hey Dan! Indeed it is.

For the record, Atul's answer works just as well, but I included the REVERSE part because of some article that I read about wildcard search performance. Of course now I can't find the article and I'm afraid I may have just made that up!

[Former Member]

Hi Daniel,

Please check below query which will give you Item ending with 'NI'

SELECT T0.[ItemCode], T0.[ItemName] FROM OITM T0 WHERE T0.[ItemCode] LIKE '%NI'

Hope this help

--

--

Regards::::

Atul Chakraborty