String Manipulation

[FUNBOY]

Hi,
Does anyone know of a function or method that i can use that, when a user enters some words into a text box, stores each seperate word into a seperate variable in SQL?

Basically what i need to do is read in any characters between white spaces tand store them in seperate variables so i can search the database for each occurence of the word - any help would be great!

Thanks

 

[PruSQLer]

Assuming you have VB available to use - you can use the Split function to put the separate words into an Array and loop thru as needed.

Dim Ary() As String
Dim Holder As String
Dim N As Integer

Ary = Split(Text1.Text, " ", -1)
For N = 0 To UBound(Ary())
Holder = Holder & "," & Ary(N)
Next N

This will put all words from the text string into the Array called "Ary". The "For" loop just gives an example of how it could be used.

 

[tlbroadbent]

As ANSI SQL doesn't provide message boxes, you should ask your question in a forum related to your client software, such as a VB, Delphi, ASP or Access forum. Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm