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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

string syntax

Status
Not open for further replies.
747576

747576

Programmer
Jun 18, 2002
97
GB
Hi,

I would like to split the values in a string:

if I have a string 'ab+cfr+ddf'

Code: 
select 'ab+cfr+ddf'

and I would like a column:
ab
cfr
ddf

or be able to select the 1st code 'ab' or the 2nd 'cfr' or 3rd 'ddf' using sql.

Thank you
 
Sort by date Sort by votes
Search for Split function in FAQ.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Auguy
  • Locked
  • Question
Connection String in .NET program Config File 2
Replies
10
Views
799
Auguy
Auguy
ahmedsa2018
  • Locked
  • Question
How to display part number based on search string by chemical id ?
Replies
3
Views
346
gmmastros
gmmastros
ahmedsa2018
  • Locked
  • Question
How to change STRING_AGG to stuff xml to split feature value by pip?
Replies
0
Views
328
ahmedsa2018
ahmedsa2018
ITALIAORIANA
  • Locked
  • Question
SQL 2012 RTRIM with Right string help 1
Replies
4
Views
392
ITALIAORIANA
ITALIAORIANA
RRinTetons
  • Locked
  • Question
MS Quefy syntax for calling SP with parameters.
Replies
1
Views
295
RRinTetons
RRinTetons

Part and Inventory Search

Sponsor

Back
Top