Hi
I'm building a query - and currently, the source is from one table one. In the query I have a lot of emailaddresses, and I want to add a column where I extract the string AFTER the @-sign, and that string I want to use on my custom column.
In Excel that's easy (sort of), I used formulas (e.g. =RIGHT(B2;LEN(B2)-FIND("@";B2))). Is that possible in a Query? I prefer the query, because, I will need to replace the table multiple times in the near future.
I would appreciate if the solution could be a little detailed, on how to build the query, e.g. do I work within SQL view, or Query builder.
Thanks.