+ Start a Discussion
sunny@99-chgsunny@99-chg 

'like' Operator Issue in the Query..

Hai,

 

     I applied 'Like' Operator on number field in the SOQL query.But it Showing an error that Like operator will not work on Number field types.

 

 I had the Number type field in database and also i Dont want to change the type here.

 

Then how to aplly 'Like' operator on number field in SOQL.Is there any other way to check the number starting with,like the functionality of 'Like' Operator.

Gunners_23Gunners_23

You cannot use Like operator for numbers (restricted to text). You can use other operators like >,<,>= etc to Query based on

 

criteria.

SFFSFF

You can, however, create a formula field that displays the string equivalent of your number field, and then apply your LIKE operator to that.

 

Good luck!