Getting a part of string
Getting a part of string
(OP)
Hello,
I need to get a part of a string and I am having a hard time
my string value is '18-18-5-4.5-35 MEQ/20 ML' and I need to get 'MEQ'
I used
LEFT(column_name,CHARINDEX('/',column_name) - 1) and I get '18-18-5-4.5-35 MEQ'
Any help is appreciated.
Thanks,
Ali.
I need to get a part of a string and I am having a hard time
my string value is '18-18-5-4.5-35 MEQ/20 ML' and I need to get 'MEQ'
I used
LEFT(column_name,CHARINDEX('/',column_name) - 1) and I get '18-18-5-4.5-35 MEQ'
Any help is appreciated.
Thanks,
Ali.
RE: Getting a part of string
RE: Getting a part of string
==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity