Skip to Content
0
Former Member
Jun 03, 2011 at 04:46 AM

SQ01 Queries; Any rules / Coding posssible?

124 Views

Hi,

I must make a query and want to use TX SQ01.

When I join the 2 tables I have the issue that the link field has a leading zero in one table and without leading zero in the other table.

So the join will not work.

I am wondering if there is any option to implement a short coding (contatenate '0' with number on one table in the query, I did not find any option in SQ01 however perhaps someone knows....

Thanks in advance,

Thomas