Replacing one item in a list......

[neomorpheus]

I have a list as below....

SYSDATE,USERNAME,CLIENTIP,URLSTEM,URLQUERY,REFERER,NODEID

I want to be able to replace the SYSDATE in the list as "convert(nvarchar, sysdate,101) as sysdate", so that my revised list would be:

convert(nvarchar, sysdate,101) as sysdate, USERNAME, CLIENTIP, URLSTEM, URLQUERY, REFERER, NODEID

Any help on achieving this is appreciated??? Thanks

 

[SidianConsulting]

If you know SYSDATE is always first in the list, you can use the ListSetAt() function like this:

ListSetAt(yourlist,1,"convert(nvarchar, sysdate,101) as sysdate")

If you don't know the position of the SYSDATE item, you can use the ListFindNoCase() function in addition to the ListSetAt() function:

ListSetAt(yourlist,ListFindNoCase(yourlist,"SYSDATE"),"convert(nvarchar, sysdate,101) as sysdate")

-Tek