Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trimming a variable

Status
Not open for further replies.

runnerlk

MIS
Jul 19, 2002
41
US
I have an application created in VB 2005 that executes the following code:

Client.Execute("RunQuery(" & Handle1 & ",\QUERY SETS\System\SpecToFortis,Combo=" & Combo_Number & vbTab & "Coverage=" & Cov_ID & ")", 10000)

The Combo_Number and Cov_ID are variables received from another application. My problem is that the Combo_Number value received has an "/" prepended and causes the query to fail(return no results). What syntax can I use to trim the first character from the Combo_Number?

Thanks
 
Example:

Code:
Dim s As String = "12435"
s = s.Substring(1)

Returns "2345
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top