How to use "not like"in Aggregate

I'm doing  the Final Project.It used 'LIKE'' to search the Name.If I want it 'NOT LIKE' something,how can I do 

there is a not operator... you could write something like:

not (Booking.GuestLastName like "%" + Session.SearchName + "%")

that would match all Bookings whose guest's last name did not include the search criteria.

HI Wentao,

You can directly use not like.


not like '%YourSearch%'


Regards,

Manish Pandey

Manish Pandey wrote:

HI Wentao,

You can directly use not like.


not like '%YourSearch%'


Regards,

Manish Pandey

Hi Manish ,


not like doesn't work in aggregates