Sir,
I have a string field value in a column Place in Place_tbl, for example
123, abdf, sygea, dsead
or
kasr, dladr, ase, 4896
I want the result without the last word
123, abdf, sygea
kasr, dladr, ase
What should be the query design
Please Help
I have a string field value in a column Place in Place_tbl, for example
123, abdf, sygea, dsead
or
kasr, dladr, ase, 4896
I want the result without the last word
123, abdf, sygea
kasr, dladr, ase
What should be the query design
Please Help