simple if contains statement

[#1]

I know this must be a simple one to solve but I cant figue it out. I'm trying to break up some data based upon an ID field. If the ID begins with v then its a product else its an order. Currently running the below everything is displaying as an order, im guessing this be because its using the * as a character instead of a wildcard.

Can someone please point me in the right direction?

if("ID"='v*', 'products', 'orders') as datatype

Thanks

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

Use the following:

=IF(WILDMATCH(ID, 'V*'), 'products', 'orders')

Hope that helps

[#3]

Many thanks, works perfectly!