F0005.Select - How To Concatenate

[problemsolving]

Hi,
i have a report that is doing a F0005.Select using the variable VA evt_F55IMPMH_POHP13 (screenshot attached)

i just want to modify it using a concat of 2 different variables. How this can be done?


Thanks

 

[Gomer79]

You can create test variable and use the text function concat( , ) to perform this task.

NewString = concat(String1,String2)

Then pass NewString into your select statement. The following thread has more detail: http://www.jdelist.com/vb4/showthread.php/17750-Concatenate-Multiple-Strings