I want to split on spaces to basically get a list of words a user may enter in a search string.

For example user may search "Blue Chevrolet Corvette"

I then want...

some debugging and i found that when you len a blank string you get 0

//returns 0

select len(' ')

I tried to split a string on a space character and the function blew up

select * from Split('one two', ' ')