I am looking for dupes in my data and want to do some analysis on the data. To do this, I need to do a substring of the field. I am using SQL. Most SQL dialects support “substring” but Studio 3T does not. I tried LEFT. But this also does not work.
I am looking for dupes in my data and want to do some analysis on the data. To do this, I need to do a substring of the field. I am using SQL. Most SQL dialects support “substring” but Studio 3T does not. I tried LEFT. But this also does not work.