Convert field value which starts with text or some special characters into 'NLL'

[nareshthavidishetty]

Hi,

Can we make a field value which starts with text or some special characters into 'NLL' .

Field Product#:

950005-11300

950040-11300

91996171-11300

Dongsheng-11300

KINTZ PLAS-11300

N/A-11300

n/a-11300

NA-11300Refer to a-11300

_XNA-11300Refer to a-11300
参考附件-11300

Thanks..

[Claudiu_Anghelescu]

IF(ISNUM(Left(YourFiled,1)), YourField, 'NLL') as YourField