The SQL query to output does not have any particular character from a string [closed]. How to solve this issue?

351    Asked by DianeCarr in SQL Server , Asked on Aug 23, 2023

I must write a SQL query condition in STRING for a data extension field. I need to write the SQL query in STRING not to invoke the ones having the third and last letter a specific character. Is there any suggestion regarding that? 

Answered by Diana Campbell

If a query does not contain SQL, but you need to call the STRING that does not have the third and last character, you can use the SUBSTRING function in the SQL query. It helps to get the third and last letter of the string. After that, use the operator NOT LIKE to extract the specific records having the specific characters you want. You can use the following query:
















Your Answer

Interviews

Parent Categories