Modify SQL Query: Update WHERE Clause not working with LOWER function

[CLashae]

Hello, I am trying to use the dynamic input to to update the where clause in my query. However, the where clause is dependent on having the LOWER() function. For example, in the database, the data in the string I need may be upper or lower case, but I don't always know. 

As a result I will typically write a query like WHERE lower(field) = 'xxxxx'

When I include the lower() function, Alteryx is not recognizing it as a WHERE clause and so this clause dos not show up in the dropdown options for 'SQL Clause to Update'.

Is there a way to fix this or a workaround I can use?

[ArtApa · Accepted solution]

Hi @CLashae - You need to enter this field manually. Have a look at the following example:

[CLashae]

Thanks @ArtApa ! I wasn't sure if it needed to be included as the drop-down since I've never seen the drop down blank before, but pasting it in manually worked out just fine. Thanks so much for the quick reply! 😊