Re: Search for a String within ntext Field


"EdwardH" <EdwardH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F153098A-DF6F-4FD5-8102-3EE4AC0B95A1@xxxxxxxxxxxxxxxx
Any pointers gratefully received

On the server (assuming SQL Server, which seems likely as ntext is a SQL
Server type name) use LIKE with a wildcard pattern:

SELECT * FROM mytable WHERE myntextcol LIKE N'%' + @SearchString + N'%'

On the client, use InStr (in VB), or CString.Find (C++/MFC), or the
Unicode-capable variant of strstr (C Runtime), etc.


-Mark


.

Relevant Pages

  • Re: What doesnt lend itself to OO?
    ... >> proxy and instructs the server to constuct the real object. ... rather than client code. ... If 'clock' is instantiated in the server, ... > for the server interface at the OOA level. ...
    (comp.object)
  • This is going straight to the pool room
    ... or not the client has privilege to do what they're trying to do, ... The server environment is this: ... 3GL User action Routines that Tier3 will execute on your behalf during the ... Routine Name: USER_INIT ...
    (comp.os.vms)
  • [Full-Disclosure] R: Full-Disclosure Digest, Vol 3, Issue 42
    ... Full-Disclosure Digest, Vol 3, Issue 42 ... SD Server 4.0.70 Directory Traversal Bug ... Arkeia Network Backup Client Remote Access ...
    (Full-Disclosure)
  • Re: What doesnt lend itself to OO?
    ... > rather than client code. ... no way to do that without also touching the object with clock semantics ... will not encapsulate both clock semantics and network semantics. ... The server can do whatever it wants ...
    (comp.object)
  • RE: Fax monitor incoming + outgoing calls?
    ... problem between the client computer and the SBS server. ... Client is using the internal IP address of the SBS server as the ... To the folder redirection GPO issue: ...
    (microsoft.public.windows.server.sbs)