Hi Loe,
Please try % in place of *.
Use like if you want the 1234 to match as shown in my attachments.
Hope this helps to what you are looking for.
![](https://higherlogicdownload.s3.amazonaws.com/PRECISELY/MessageImages/8cf639cc2b2d4100a0137334ce0f92b7.png)
![](https://higherlogicdownload.s3.amazonaws.com/PRECISELY/MessageImages/aa52c099e33d4b979bab0caa4a250d65.png)
------------------------------
Benjamin Kielas
Supervisor SAP Master Data
Generac Power Systems, Inc.
WAUKESHA WI
------------------------------
Original Message:
Sent: 09-12-2024 09:56
From: Leo van Horrik
Subject: Does not contain * (asterisk)
Hi,
I am creating a Winshuttle query where I want to add a criteria where the results does not contain the character "*" (asterisk).
For example, if I have these material numbers: 1234, 1234*, 12*34 and 1234**, I want the result to be only material number 1234.
I think I have to use the operator "Not Like" and then use an escape. But I don't know how to create the escape in a Winshuttle query.
Hopefully someone can help me out.
Greetings, Leo.
------------------------------
Leo van Horrik
Knowledge Community Shared Account
Burlington MA
------------------------------