hi,

there is one field called sales no.
it should generate like this if first there is null value then
S001, not null then next value should be s002

if i written the script as follows:

select max(dmoes200.slno):slno from dmoes200
vsln = strip$(shiftl$(slno))(2;4)
vsln1 = val(vsln) + 1
while i was displaying the value of vsln it was giving 1 for the
first record .
i donot how to concate 's'

please suggest for the same.

bye

Reeta,

You cannot use alphabets for numeric fields. If its a string based field, then you can concatenate -

value = "S" & str$(sequ.number)