left Function on an import

[Drew101]

for some reason my Left([CCCode],2) is not working after my excel file has been imported into a table. How can I fix this

[davegri]

is not working

More information please. We can't see what you are doing, you have to tell us.

[aytee111]

More information please:
- what it looks like before
- what it looks like afterwards
- data type of field
- what does not working mean

[rpeare]

if your field is null (has no length) the right function will bomb out

try something more like

iif(len([ccode]) >2, left([ccode],2), null)