<div>
Maybe a type casting problem or using he wrong quotes.<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-41492385-1"><span>Update Student set Picture = cast(SID as varchar(100)) + '.jpg'</span>
</code></pre>
<br />
Failing that, if you need to image name out in a SQL call, make it a derived field so you don't need to store the value twice.
</div>


<div>
what is the datatype of Picture? Of SID?<br />
<br />
If SID is numeric, try:<br />

<pre><code class="code-1 nolinks" id="code-20-41492388-1"><span>Update Student set Picture = cast(SID as varchar) + ‘.jpg’</span>
</code></pre>
</div>


<div>
arana is correct, the first quote is reversed!
</div>


<div>
Well, I pasted the update from an e-mail a friend sent. The '.jpg' looked the same and in black. &nbsp;When I actually type the statement into QA the '.jpg' is red. Does this sound correct?<br />
<br />
Picture is a (varchar(20),Null)<br />
SID is a (varchar (12), Not Null)
</div>


<div>
If SID is a varchar then no need to cast. It'll be as I said, in that you used the wrong quotes.<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-41492453-1"><span>update student set picture = SID + '.jpg'</span>
</code></pre>
</div>


<div>
Don't use &nbsp; &nbsp;ID + ‘.jpg’ &nbsp; but &nbsp; ID + '.jpg' &nbsp; &nbsp;-- do you see the apostrophes difference here?<br />
<br />
Back apostrophes cannot be used to enclose text literals. <br />
<br />
Back apostrophes are used in MySQL to enclose column and table names sometimes.
</div>


<div>
I used the ' &nbsp;mark located on the key with the &quot;&nbsp;marks before and after the text and it worked. &nbsp;I did not use the ` mark on the key with the ~. &nbsp; Typing it in rather than pasting did the trick (that and seeing the red!). &nbsp;Thanks everyone for such quick responses.<br />
<br />
--SM<br />
<br />
-
</div>


<div>
Look at your question: &nbsp; ‘.jpg’ &nbsp;... &nbsp;It does not contain &nbsp;' (apostrophe)... But it also does not contain back apostrophe...<br />
It contains left and right single quotation marks... :-)
</div>


<div>
<div class="content wysiwyg-content">
I'm trying to run this update statement in SQL 2000 (don't laugh) ;<br />
<br />
Update Student set Picture = SID + ‘.jpg’<br />
<br />
and I'm receiving the following error:<br />
<br />
Server: Msg 170, Level 15, State 1, Line 1<br />
Line 1: Incorrect syntax near '‘'.<br />
<br />
Do I need parentheses around SID + ‘.jpg’<br />
<br />
Thanks
</div>
</div>


I'm trying to run this update statement in SQL 2000 (don't laugh) ;

Update Student set Picture = SID + ‘.jpg’

and I'm receiving the following error:

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '‘'.

Do I need parentheses around SID + ‘.jpg’

Thanks

This query isn't working what do I do?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.