| Author |
 Topic  |
|
|
ntn104
Posting Yak Master
162 Posts |
 Posted - 05/04/2012 : 10:47:15
|
Hello,
How do I get rid of some symbol in front of the field name. For example: ABCD, I just want to display ABCD only.
Thanks, |
|
|
khtan
In (Som, Ni, Yak)
Singapore
16769 Posts |
Posted - 05/04/2012 : 10:50:50
|
is it always the same symbol ? if it is so, you can use replace() to remove it
KH
Time is always against us
|
 |
|
|
ntn104
Posting Yak Master
162 Posts |
Posted - 05/04/2012 : 11:02:56
|
yes it always symbol and space after...
and want to get rid space and that symbol...
Thanks,
quote:
Originally posted by khtan
is it always the same symbol ? if it is so, you can use replace() to remove it
KH
Time is always against us
|
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
16769 Posts |
Posted - 05/04/2012 : 11:06:42
|
so the text that you want is starting from 3rd character ?
substring( <string> , 3, len(<string>) - 2)
KH
Time is always against us
|
|
|
|
ntn104
Posting Yak Master
162 Posts |
Posted - 05/04/2012 : 11:10:10
|
I got error message for this, like missing a parenthesis...st..
select substring(STREET_2 , 3, len(STREET_2) - 2))
from table
what I did wrong? thanks,
quote:
Originally posted by khtan
so the text that you want is starting from 3rd character ?
substring( <string> , 3, len(<string>) - 2)
KH
Time is always against us
|
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
16769 Posts |
Posted - 05/04/2012 : 11:44:53
|
you have mismatched parenthesis.
See the extra one in red
select substring(STREET_2 , 3, len(STREET_2) - 2))
from table
KH
Time is always against us
|
Edited by - khtan on 05/04/2012 11:46:14 |
|
|
|
madhivanan
Premature Yak Congratulator
India
22469 Posts |
Posted - 05/07/2012 : 07:10:34
|
Alternate
right(col,len(col)-2)
Madhivanan
Failing to plan is Planning to fail |
|
|
|
ntn104
Posting Yak Master
162 Posts |
Posted - 05/07/2012 : 11:21:12
|
Thanks...it worked now...
quote:
Originally posted by khtan
you have mismatched parenthesis.
See the extra one in red
select substring(STREET_2 , 3, len(STREET_2) - 2))
from table
KH
Time is always against us
|
|
|
| |
Topic |
|
get rid of symbol character in the field
