unicode error

[Former Member]

Hi ,

For following syntax -

SHIFT S_AUSVN-LOW LEFT UP TO 10.

I am getting this error -

"10" must be a character-type data object (data type C, N, D, T or STRING)

How to solve this problem ?

[Former Member]

Put 10 in single quotes ...

SHIFT S_AUSVN-LOW LEFT UP TO '10'.

[Former Member]

Hi,

SHIFT is a string operation and can be only used with string or character fields.

The format is :-

SHIFT <c> BY <n> PLACES.

Thanks,

Daya

[Former Member]

SHIFT S_AUSVN-LOW LEFT UP TO '10'.

This will try to shift the string to left till '10' Occurs in String. Just Use quotes.

If you want to shift by 10 places use:

SHIFT S_AUSVN-LOW LEFT BY 10 Places.

Regards,

Gurpreet