Getting a part of string

[ahadali79]

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.

 

[sxschech]

Did you try Mid or Substring instead of Left?

 

[johnherman]

Also of note here is that there are database-specific syntax to assist with string manipulation, but they are not ANSI - they are database specific. For instance, CHARINDEX (T-SQL) and INSTR (PL/SQL) do the same thing; they find the location of a substring within a string.

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity