TransWikia.com

What is wrong with this LIKE in an Query?

Salesforce Asked by Johann Mayer on December 10, 2021

i am facing a strange problem using a Like operator in a query.

I want to query fields (String) containing values like ‘VG004-0383-543830399298’

Now it seems that the query only delivers results if the LIKE condition contains a non-numeric character.

For example

LIKE '%0383%'

does not find the entry.

LIKE '%-0383%' 

finds the entry.

Whats wrong?

Thanks in advance,

Johann

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP