Contains formula for integers

[Inactive User]

Hi,

I have to search for a particular number(6038) in the full number ( eg 3424326038433). In SQL i can use like function to solve this, not sure if there is something similar in alteryx.

For example 

Value

1000
10006038
6038
53443603832
3436038

I am using the following query but alteryx for some reason isn't giving the correct answer

keep?= if FindString("6038", [Value]) then 1 else 0 endif 

Output ->

Value Keep?
1000 1
10006038 1
6038 0
53443603832 1
3436038 1

Thanks!

[MarqueeCrew · Accepted solution]

Please try:

Contains(ToString([Numeric Field]),"6038")

Cheers,

Mark