SQL - he conversion with value varchar ´6000000001" overflowed and int value,

SELECT TOP (100) PERCENT vkorg, vtweg, vbeln, spart, posnr, bstdk, auart, bezei, zterm, zterm_desc, repr, nrepr, waerk, pltyp, solin, nsoli, resppag, nresppag, destmerc,

	ndestmerc, cod_soli, stras, ort01, smtp_addr, telf1, grcli_soli, descr_gr_cli, kvgr3, nif_cif, matnr, maktx, ptyv, vtext, precio_uni, kwmeng, kzwi1, dto, netwr, abgru,

	zzmayorista

FROM dbo.flash

WHERE (abgru = '') AND (vbeln NOT IN (70003158, 70003157, 10014318)) AND (auart IN

	(SELECT auart

	FROM dbo.filtro_auart))

-- Example using a variable of type string, there is an automatic truncation

-- no get error message

declare @myvar char(10)

set @myvar = '160000000001'

select len(@myvar)

select 'result:', @myvar

select cast(@myvar as int)

-- But if we try to enter a higher value to a table, then we get an error

DECLARE @MyTableVar table(

    MyValue char(10))

INSERT INTO  @MyTableVar VALUES('160000000001')

Msg 8152, Level 16, State 14, Line 14

String or binary data would be truncated.

The statement has been terminated.

WHERE     (abgru = '') AND (vbeln NOT IN (70003158, 70003157, 10014318))

WHERE     (abgru = '') AND (vbeln NOT IN ('70003158', '70003157', '10014318'))