Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting a part of string

Status
Not open for further replies.
ahadali79

ahadali79

Programmer
Aug 16, 2019
1
US
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.
 
Sort by date Sort by votes
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


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
SORT by part of filed 2
Replies
5
Views
515
2009luca
2009luca
mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
366
mmiah1982
mmiah1982
BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
414
carp
carp
BobThornton
  • Locked
  • Question
Count records until a record value changes
Replies
2
Views
562
carp
carp
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
380
carp
carp

Part and Inventory Search

Sponsor

Back
Top