Support Portal

for ProcessRobot and WinAutomation

Start a new topic

SQL NOT LIKE

hi, is there an equivalent of not like in sql in softomotive. I know LIke is working not sure if there is NOT LIKE. thanks


1 person has this question

ADMIN

Hey Em, 


All SQL queries supported by SQL generally, are supported by WinAutomation as well. 


Thanks.

can you give me the right syntax for that Im having an error. this is my sql 


SELECT [%worksheet%].[Customer], [%worksheet%].[Rep] , [Sheet1$].[Location] as "%loc%" from [%worksheet%] inner join [Sheet1$] on [%worksheet%].[Customer] 

NOT LIKE '\%%loc%'


I dont know how will I add the wildchar in the column so I used a variable to get first the column value

with is the loc variable

ADMIN

Hi Em,

We can add wild characters in WinAutomation SQL actions similar to the normal queries which we give directly in SQL. The only exception here is that when we pass on the value as a variable, the value is stored within "%%" two percentage values. So if we want to use a variable and % as a wildchar, then we must first escape the % wildchar with \.

 In this case the expression for LIKE or NOT LIKE will be \%%variable% or %variable%\%. Similarly you can call a variable for column name also, provided you have stored the column name in a variable beforehand. PFA screenshots for reference.

Login or Signup to post a comment