---
title: "Syntax error converting the varchar value"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/119874-syntax-error-converting-the-varchar-value"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Jesper T"
published: "2005-01-11T22:51:13.000Z"
updated: "2005-01-11T23:04:52.000Z"
replies: 2
views: 235
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/119874-syntax-error-converting-the-varchar-value"
---

# Syntax error converting the varchar value

## #1 — Jesper T, 2005-01-11T22:51Z

Det klickar på det rödmarkerade, vad kan vara fel?

```
ALTER PROCEDURE sh_getPropfromAdv
	(
	@id int,
	@sort as varchar(20)
	)

AS
Declare @QString nvarchar(500)

Set @QString = 	'SELECT id, country
		FROM tbl WHERE uid = [red]'+ @id +'[/red]
		ORDER BY '+ @sort

exec sp_ExecuteSql @QString
RETURN
```

Permalänk: https://www.webforum.nu/p/119874

## #2 — emission, 2005-01-11T22:53Z

@id är en int, och kan inte konkateneras med strängar

\+ str(@id as varchar) +

eller använd cast eller convert

Permalänk: https://www.webforum.nu/p/1525628

## #3 — Jesper T, 2005-01-11T23:04Z

\+ str(@id) +
Funkar bra. 
Tack!

Permalänk: https://www.webforum.nu/p/1525633

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/119874-syntax-error-converting-the-varchar-value