I'm not sure about the indexing and performance impacts, but I think you
could use SUBSTRING with a regex to pull out the client name, and then
match on that.
SELECT substring('Client Name - Description' FROM '^(.*) [-]');
substring
-
Client Name
On Thu, Feb 28, 2013 at 12:02 AM
On 02/28/2013 06:12 PM, John R Pierce wrote:
> On 2/27/2013 10:35 PM, Ghislain Hachey wrote:
>> I have a varchar column with content such as "Client Name - Brief
>> Description of Problem" (it's a help desk ticket system). I want to
>> generate reports by clients and the only thing I can base my qu
On 2/27/2013 10:35 PM, Ghislain Hachey wrote:
I have a varchar column with content such as "Client Name - Brief
Description of Problem" (it's a help desk ticket system). I want to
generate reports by clients and the only thing I can base my query on
is this column. The client names often contai