Return String from the right of space. 1

[rtshort]

I have a lot of tables in SQL Server. Some of the names have the space in different places. I'm using remote scripting to get the names of all of the tables I want to use but I want to trim off everything on the Left of the string. Tables are named like:

1Eng Carb
1Eng Electrical
11Eng Carb
11Eng Electrical
111Eng Carb
111Eng Electrical

I'm filling list boxes and all I need is the Carb or Electrical part of the name in the listbox. No matter what the position of the space I just want the last part in the listbox. I use the sql Statement:

"Select * from SysObjects where name like '%11Eng%'

Since it's in an array I have to split the names.

AddToList= Split(rs.Fields("Name&quot.value, ",&quot

How do I trim the name so all I get is what is after the space?
Rob
Just my $.02.

 

[spazman]

Try this;

For i = 0 Ubound(AddToList)
AddToList(i) = Right(AddToList(i), Len(AddToList(i)) - Instr(AddToList(i), " &quot)
Next

 

[rtshort]

Thanks a million Spaz. For now I'll have to owe you and just give ya a star! Rob
Just my $.02.