Like in query

Hot Topic

USING an CASE statement to Derive a Field
Sql Server Encryption
cant connect
where are the stored procedures fields in report design?
Changes not replicated to subscriber
SQL Server 2005 Service Pack 1 is now available
Imaging System - SQL Server 2000 / 2005 or Oracle10g
Cannot talk to Dataset!
Bug in Flat File Connection Object: Risky!!!!
Need help rotating a table

SQL Server

Using a OCX created for use with Access
~* Difference between RDL and RDLC *~
Copy data from one table to another
Query Empty node
Merging columns
Joins with XQuery
stored procedure that performs a search is too cumbersome
Management Studio Scripting Bug?
Disapearing Records
cannot create database error in sql express 2005

Like in query

strSQL = "SELECT Naam FROM tblKlanten WHERE code LIKE '%" & str & "%'"

it works in sql but doens't in sql mobile how do i solve this



Answer this question

Like in query

  • Rafael Turon

    It works very well in SQL Mobile too.  But I dont know why you ran into problems.  What error did it give   What is HRESULT

    Thanks,

    Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation



  • Manmeet Panigrahi

    What's happening for me is I'm using it in combination with a join, and it's returning all rows from the other table, not just the ones that are linked to the LIKE result.

    Any thoughts

    Thanks,
    Dave

  • Joe127

    what is the data type of the 'code' column in tblKlanten   is it numeric

    -Darren

     



  • shunm_ms

    Thanks for replying. Everything is solved now.

    Cheers,

    Dave

  • Samuel D. Colak

    Unless you post complete detail, we can not answer your question.

    Thanks,

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



  • Like in query
Answer this question