I need to concatenate 2 fields together in a load script. Trying the following:
'soln'&"so_nbr"&' 00'&"so_line_nbr" AS soln_xudt_key
I need 5 spaces and 2 zeroes after the first field. The spaces and 1 zero are getting truncated after the load. The result is "soln049178 001". Desired result is "soln049178 0001". How can I accomplish this?
@dthornburg when you try to append spaces (using keyboard space key), it auto trims the spaces. You explicitly need to append the space character using chr() function
'soln'&"so_nbr"&Repeat(chr(160),5)&'00'&"so_line_nbr" AS soln_xudt_key
@dthornburg when you try to append spaces (using keyboard space key), it auto trims the spaces. You explicitly need to append the space character using chr() function
'soln'&"so_nbr"&Repeat(chr(160),5)&'00'&"so_line_nbr" AS soln_xudt_key
