exp help

[abhaysingh]

HI all

i have one table field which contain year 2014 and some integer values in it .

i.e.

Table

2014

1.2

2.3

2.4

1

3 and so on

i want to pick 2014 from it as a year and also want to add 2015 in it.

how can i do it.

output i need is

i.e.

Table

2014

2015

1.2

2.3

2.4

1

3 and so on

kindly help asap

[alexandros17]

If you need to add 2015 as valur for your field then:

Load * from table

concatenate

load * inline [

myfield

2015

];

let me know

[anbu1984]

Tbl:

Load * Inline [

Txt

2014

1.2

2.3

2.4

1

3 ];

Load Txt+1 As Txt Resident Tbl Where IsNum(Txt) And Len(Txt) = 4;