SQL Select Query with String Manipulation
From: Andrew Cox <a7t2fz001_at_sneakemail.com>
Date: 24 Oct 2002 14:37:04 -0700
Message-ID: <c40fc812.0210241337.76edb331_at_posting.google.com>
02 A code with description
24 Some description here
42 Another Description here
A description without a corresponding code Another description without a code
Date: 24 Oct 2002 14:37:04 -0700
Message-ID: <c40fc812.0210241337.76edb331_at_posting.google.com>
Hi,
I'm trying to do a little string manipulatin within a SQL Select statement and I'm not sure if it's possible or not. Here's the type of data that I have in the field I'm concerned with:
02 A code with description
24 Some description here
42 Another Description here
A description without a corresponding code Another description without a code
Okay ... what I want to do is strip the number codes from the descriptions that have them *within* the SQL Select query. I need to do it within the query because of other constraints (I have to pass the whole query to a ColdFusion custom tag). The problem as I see it is that not all of the fields will have the leading code (though most of them do).
Is it possible to do that kind of string manipulation within the SELECT statement?
Thanks for your help! Received on Thu Oct 24 2002 - 23:37:04 CEST