• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1678
  • Last Modified:

Using forward slash "/" in query

I am trying to update a table using the following query:
update [daily sales totals by account type]
set [date] = mo+'/'+dy+'/'+YR

MO, DY and YR are fields in the table [daily sales totals by account type] and are all int.  [date] is a varchar field.

I am getting the following error:
Server: Msg 245, Level 16, State 1, Line 1
Syntax error converting the varchar value '/' to a column of data type int.

I have tried using CAST, CONVERT, & (instead of +), single quotes, double quotes and have not been able to get this one to work.  I am needing a swift kick in the butt - 'cuz I'm sure this one is something simple that I am overlooking...been working on this issue too long...

Can someone please tell me where I am going wrong?

Thanks!

Sean
0
saladart
Asked:
saladart
1 Solution
 
NightmanCTOCommented:
update [daily sales totals by account type]
set [date] =cast(mo as varchar(2)) + '/' + cast(dy as varchar(2))  + '/' + cast(YR as varchar(2))
0
 
rw3adminCommented:
cause your mo, dy and YR are int
try
set [date] = cast(mo as varchar)+'/'+cast(dy as varchar)+'/'+cast(YR as varchar)
0
 
saladartAuthor Commented:
See - I knew it was something simple...

Thanks Nightman - you were first to answer...

Sean
0
 
Scott PletcherSenior DBACommented:
SQL will automatically recognize YYYYMMDD as a valid format, so this is easier to do:

UPDATE [daily sales totals by account type]
SET [date] = yr * 10000 + mo * 100 + dy
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now