i want to use substring function to peel of first two characters stored in a database field. i'm using sql. im not quite sure what the syntax will be.
Const strSQL as String = "SELECT SUBSTRING(emailKey,2,4), primaryKey FROM Tracker"
i kinda figured out the above statement doesnt work. all i want is extract the first two letters from the emailKey field. any help?
what I would like to do is remove a substring from a full string and display the modified string my basic code should be some like this:
strSearchString = FullString
strSearchFor = "SubString"
If InStr(1, strSearchString, strSearchFor) > 0 then
Response.write (FullString - Substring)
does anyone have any idea how I would go about doing this?
I have records from the database for locations as "Baltimore Service center","Vancouver Service center", "Toronto Service center"...etc.I am trying to get a substring where it diaplays just the location and strips Service center ex : Baltimore
View Replies View RelatedI have this sentence
"I like to eat apple"and I need to change it to "i like to eat orange"
i have to check either the string contain apple or not. If yes, then i need to replace the "apple" to "orange" else i done nothing to the string.
can anyone show me how to write this in asp code?
does exist any command to find any substring in a string ? for example if i want to find if there is any + in a string , how can i do this ? Code:
View Replies View Related