I am trying to split a string that is made up of three substrings
seperated by non-breaking spaces. In fact the string was
created from the attached code snippet i.e. from the concatenation of three database fields
and replacing all spaces with non-breaking spaces.
On the firing of a certain event I am attempting to break up the string
into its substrings using the following code:
Dim values() As String = Split(EMPLIST.SelectedValu
e, Chr(160), 3)
The first substring (values(0)) comes out correct but the second is invariably an empty string and the third is a concatenation of the last two substrings that I intended to separate.
Anybody sees why I am not getting my three substrings?
SELECT Replace(LEFT(RTRIM(FIRST_NAME) + ' ', 10) + LEFT(RTRIM(LAST_NAME) + ' ', 10) + CAST(SSN AS char(10)), ' ', Char(160)) AS column1 FROM EMPLOYEE where DISTRICT = '" + Request.QueryString("district")