SQL Like queries in ServiceNow

[nidhi_hassan]

Whats the GlideQuery equivalent of:

select * from Employee where name like 'John%'

[_Gaurav]

Hi @nidhi_hassan 
var gr = new GlideRecord('Employee');

gr.addQuery('name','LIKE','John');

gr.query();

if(gr.next()){

//use the gr object to get the value

}

Please mark this as helpful and accept it as a solution if this works for you.
Thanks!

[Parth_Poriya]

Hi

You can try with

var gr = new GlideRecord('Employee')

gr.addQuery('field_name','LIKE' ,'John')