Hello All,

As per MSDN Replace command syntex is :

REPLACE FieldName1 WITH eExpression1 [ADDITIVE]
[, FieldName2 WITH eExpression2 [ADDITIVE]] ... [Scope]
[FOR lExpression1] [WHILE lExpression2] [IN nWorkArea | cTableAlias]
[NOOPTIMIZE]

In my program I am replacing values in table like this:

Case : 1
Select Customer
Append Blank
Replace Cust_Code with '0001'
Cust_Name with 'AJAY MISHRA'

Case : 2
Select Customer
Append Blank
Replace Cust_Code with '0001',;
Cust_Name with 'AJAY MISHRA'

Both is working fine. I am curious to know that how case 1 is working fine (without '; separator).

Please comment on this feature.

TIA
Ajay Mishra