Split function

[faithful1]

Please help. this would seem to be very easy, but turning into a nightmare for me.
I need a split function that returns the last section of a string delimited by a given character.

For example, I would like to split 'test-01-02' by '-' and have it return 02. Please help. Thanks!

 

[r937]

string functions vary from one database system to the next

it would probably be best if you post this question in the forum for your particular database system

in mysql, for example, you would use

SUBSTRING_INDEX('test-01-02', '-', -1)

r937.com | rudy.ca

 

[bluecjh]

SQL SERVER 2000

you could convert the following into a user defined function?

DECLARE @StringProvided 		VARCHAR(50),
	@Position1 			INT,
	@StringRequired 		VARCHAR(50)

--example string
SET @StringProvided = 'lkjl-hand-oxen'

SET @Position1 = (SELECT CHARINDEX('-', @StringProvided))


SET @StringRequired = RIGHT(@StringProvided, LEN(@StringProvided) - 
(SELECT CHARINDEX('-',@StringProvided, @Position1 + 1)))



SELECT @StringRequired

BlueCJH