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,

Instead of using "%" as the wildcard operation, please try with "*" asterix in your query string in Execute SQL Statement action . In this case

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

NOT LIKE '\%*loc%'

Also I'm not sure about the backslash in the last. If the above query does not work, can you remove the backslash and check.



Login or Signup to post a comment