0

Hi There,

I would like to know if it's possible to use or what I could use to get the required results.

The values

+2711
 081
 076
 086
 080
 9011
 6547082
 9013
 9039
 9086
 9041
 +27084
substring(table,length(tbl_code),length(tbl_code))=trim(tbl_code)

I have different values lengths in my MySQL table that's not showing all my values correctly.

substring(table,1,length(tbl_code))=trim(tbl_code)

Kind Regards

2
Contributors
1
Reply
3
Views
6 Years
Discussion Span
Last Post by twiss
0

It might be just me, but I've got no clue what you want to do whatsoever. What are those values, where do they come from, what has to be done with them, what doesn't show correctly, etc.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.