Hi All,
In my case, I would like to drop anything after the date (YYYY-MM-DD).
I tried using REPLACE ([ColumnName], 'Apple(s)', '') but that only remove the part 'Apple(s)' not the number before it.
My data looks like this:
1 2000-10-15 2 Apple(s)
1 2011-08-12 104 Apple(s);1 1985-06-14 14 Apple(s);1 2004-07-18 25 Apple(s);
How should I query this so I am left with the following:
1 2000-10-15
1 2011-08-12;1 1985-06-14;1 2004-07-18;
Thanks so much.