Showing posts with label filter. Show all posts
Showing posts with label filter. Show all posts

Monday, March 26, 2012

Replication Dynamic Filter SQL SERVER 2005 June CTP and Mobile 200

I'm trying to filter an article by a Int field with the following
ID=CONVERT(int,HOSTNAME()), but ID=CONVERT(int,'1') works. This used to work
in previous versions.
Thanks Mike Smith
The CONVERT errors out with convertion from nvarchar to int not allowed.
Also, I know the function is HOST_NAME(). Typo.
Thanks Mike Smith
"msmith" wrote:

> I'm trying to filter an article by a Int field with the following
> ID=CONVERT(int,HOSTNAME()), but ID=CONVERT(int,'1') works. This used to work
> in previous versions.
> Thanks Mike Smith