In C# regular expression

using System.Text.RegularExpressions;

string data="ash02389-|,jkhsd";

Regex TestValidData = new Regex("[a-zA-Z0-9-,|.; ]*");
Match TestResult = TestValidData.Match(data);
if (TestResult.ToString()==data)
{
//String valid
}
else
//String not valid
.................................

Split String in MS SQL

CREATE FUNCTION SplitString
(
-- Add the parameters for the function here
@myString varchar(500),
@deliminator varchar(10)
)
RETURNS
@ReturnTable TABLE
(
-- Add the column definitions for the TABLE variable here
[id] [int] IDENTITY(1,1) NOT NULL,
[part] [varchar](50) NULL
)
AS
BEGIN
Declare @iSpaces int
Declare @part varchar(50)

--initialize spaces
Select @iSpaces = charindex(@deliminator,@myString,0)
While @iSpaces > 0

Begin
Select @part = substring(@myString,0,charindex(@deliminator,@myString,0))

Insert Into @ReturnTable(part)
Select @part

Select @myString = substring(@mystring,charindex(@deliminator,@myString,0)+ len(@deliminator),len(@myString) - charindex(' ',@myString,0))


Select @iSpaces = charindex(@deliminator,@myString,0)
end

If len(@myString) > 0
Insert Into @ReturnTable
Select @myString

RETURN
END
GO


Select * From SplitString('Hello John Smith',' ')
select * From SplitString('Hello**John**Smith','**')