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.
isnull()
Hot Topic
- sql server express loses ability to write to database
- Cache Problem
- Report task?
- OutputDebugString from script
- Dataflow where sourcecolumns vary ?
- How to ignore timepart when using LookUp with date.
- Error exporting a subreport to Excel!?
- FileWatcher Task or System.IO??
- Showing server status in SSMS
- Table Name Drop Down
SQL Server
- Repeat Group Header on new page
- using distinct on one column only
- DHCP Service fails to start after installing SQL Server 2005 April CTP
- SQL Server 2005 Express limits
- Error rendering sub-reports
- MDX Sum syntax problem
- wmi event watcher task
- Properties affected by Expressions
- SQL Server (Personal) Instance Hung Up during uninstall
- data not flowing out of flat file source
isnull()
Lampkin
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
Trenton1
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.
Tyler Whitney-MSFT
oky
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