Expr1: Left([dbo_ttipcs021490].[t_item]|12)"

[matjcb]

I am stumped

Last Year this i had a left function looked like "Expr1:
Left([dbo_ttipcs021490].[t_item],12)"


I converted thie database from 97 to 2000 and today it looks like this

Expr1: Left([dbo_ttipcs021490].[t_item]|12)

what is this "|" bare? Should it not be a ","

When i copy this this to another database query it does not work but it does
still from where i copy from.
is there and update or something i am missing?

 

[Maurice]

Maybe the regional settings in windows are bugging you. Try to figure out if
these settings are the same as on your pc.

 

[matjcb]

Thanks Maurice
It was the Regional settings

--
JB

Maybe the regional settings in windows are bugging you. Try to figure out if
these settings are the same as on your pc.
--
Maurice Ausum

I am stumped

Last Year this i had a left function looked like "Expr1:
Left([dbo_ttipcs021490].[t_item],12)"


I converted thie database from 97 to 2000 and today it looks like this

Expr1: Left([dbo_ttipcs021490].[t_item]|12)

what is this "|" bare? Should it not be a ","

When i copy this this to another database query it does not work but it does
still from where i copy from.
is there and update or something i am missing?