index > SQL Server Everywhere Edition > isnull()

isnull()

does sql server mobile 2005 support the isnull function? I'm getting an error when I try to use it and I don't know if it is becuase of using the isnull function or not, but when I run the same query on Sql Server 2005 it works fine.

INTPnerd

to answer my own question, yes you can use isnull in sql mobile. Specifically I am trying to run this query:

select (isnull(StreetName + ' ', '') + isnull(StreetSuffix + ' ', '')) as Street from Meter

both StreetName and StreetSuffix are nvarchar values. This works fine on Sql Server 2005, but on Mobile it says something about errors in command and column name not valid.

INTPnerd

I just ran this query:
select (isnull(StreetName, '')) as Street from Meter

this query runs on both Sql Server 2005 and Mobile, but on Server it displays the values as text(the StreetNames), but on Mobile it uses boolean values. How do I select the text?

INTPnerd

I got it working using the COALESCE function

INTPnerd

ISNULL() is not supported in Microsoft SQL Server Mobile/Everywhere. Hence, please dont rely on it though it does not through any syntax error.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

Please hit "Yes", if my post answered your question(s). All postings are as-is and confer no rights.

Laxmi Narsimha Rao ORUGANTI MSFT

reply 5

You can use google to search for other answers

More Articles

• Ole DB Example For Windows Mobile 5.0

• SQL Server Connection Error

• SQL Express --Windows Authentication problems

• File size limit / offline cache

• Transform??sql server mobile edition database to sqlce2.0 format.

• Debuggin on PDA

• SQL Server CE and Memory Issue

• Creating SQL Server 2005 Mobile Edition On Desktop

• Emulator Error to replicate data on SQL server

• Database connections

Welcome to Bokebb New Update

New Articles

• Setting up publication for merge replica
• SqlServerCe.dll
• RDA Pull method not creating tables/inse
• Index corrupted
• MDB to SDF
• RAPI, CCeDBDatabase, EDB, CEDB, and the
• SET IDENTITY_INSERT tablename ON
• Return Top row from a ResultSet - SQL Se
• Problems installing SQL Server 2005 Mobi
• SQL Server 2005 Replication and views
• SQL Server Mobile Bug?
• SQL CE 2.0 and SQL Mobile 2005
• SQL Mobile Installation Problem on Device
• Subset of TSQL supported by SQL Server m
• DataBase Connection for VS2005 C++ for D

Hot Articles

• Maximum length sql statement that can be
• RAPI fails on CeMountDBVol (WinMobile 5)
• SQL query problem....newbie question
• SQL server mobile deployment problem
• ssevaccesssync service does not start
• RDA Pull with existing table
• RDA with Linked Servers
• Should I use Merge Replication ahead 3rd
• cannot generate ResultSet code
• EDB record limits and EDB vs RAPI
• Application hangs on SqlCeConnection.Dis
• Access Database Synchronizer for SQL Exp
• Merge Replication Question
• Can I change a SQL Server Everywhere dat
• Is it a bug ?

Recommend Articles

• RAPI fails on CeMountDBVol (WinMobile 5)
• Please help : A call to SQL Server Recon
• "SQL Everywhere" is a Sybase t
• Sql Server 2005 Mobile/RDA connection pr
• SQL 2005 Mobile loading 2003 Cabs
• RDA and replication
• Header Corruption Error
• creating tables
• (SQL Mobile)Can SELECT, but cannot INSER
• sql server2005 and sql mobile DB (.sdf)
• Is IIS always required for replication?
• Where to find Sql Server CE package...?
• Problem using SQL Server Mobile 2005 wit
• Everywhere Edition and VS Express
• Microsoft SQL Server Mobile Edition data