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

  • Thread starter Thread starter matjcb
  • Start date Start date
M

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?
 
Maybe the regional settings in windows are bugging you. Try to figure out if
these settings are the same as on your pc.
 
Thanks Maurice
It was the Regional settings

--
JB


Maurice said:
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


matjcb said:
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?
Click to expand...
Click to expand...
 
Back
Top