counting characters in a field
i'm a news.
but i am trying.
within a certain field (urlref), i am trying to truncated just the everything left of the '?'.
a typical entry in this record for this field would be: ("http://email@example.com")
i know i would have to:
get count of characters in the whole string x
find where ? character is charindex('?',URLref)
get count y after ?
subract y from x
i'm confusing myself.