On 5/16/20 9:31 AM, PALAYRET Jacques wrote:
Hello,
Perhaps, a statement like :
substring(theString, 1, length(theString)-position(',' IN
reverse(theString)))
with theString 'Class V,Class VI,Class VII,Competitive Exam,Class
VIII*,Class' for example.
That's cool. I did a little fiddling with above:
SELECT
substring(
left('Class V,Class VI,Class VII,Competitive Exam,Class VIII,Class
X,Class XI,Class IX,Class XII', 60), 1, length(
left('Class V,Class VI,Class VII,Competitive Exam,Class VIII,Class
X,Class XI,Class IX,Class XII', 60)) - position(',' IN reverse(
left('Class V,Class VI,Class VII,Competitive Exam,Class VIII,Class
X,Class XI,Class IX,Class XII', 60))))
substring
--------------------------------------------------------
Class V,Class VI,Class VII,Competitive Exam,Class VIII
Regards
----- Météo-France -----
PALAYRET JACQUES
DCSC/MBD
jacques.palayret@xxxxxxxx
Fixe : +33 561078319
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
