Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2006-02-08 : 03:24:19
|
| i have an ineer join selectwhere i want to make a check thattable1.id=table2.field4the problem is thattable1.id is numerictable2.field4 is nvarchari tried to use casttable1.id=cast (table2.field4 as numeric)or table1.id=cast (table2.field4 as bigint )but i get the message that error converting nvarchar to numeric/bigintany idea?thnaks in advancepeleg Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-08 : 03:35:16
|
| try convert table1.id to nvarchar and compare ?----------------------------------'KH' |
 |
|
|
|
|
|
inner join and comperison between numeric and nvar