It is ok...it is only for a local PC and not on a live server..(but thanks for the link)
and thanks to Chris & Rod..
Carl
On 10/9/06,
Haikal Saadh <[EMAIL PROTECTED]> wrote:
In our experience, SQL "Like"s will lead to server meltdown, soon to be
followed by forceful ejection from the building, by angry server
admins, through the nearest closed window.
A better option would be SQL Server's built in full text indexing
capabilities:
http://www.developer.com/db/article.php/3446891 for an overview
[EMAIL PROTECTED] wrote:
> select * from dbTable
> where CustomerID not like '%bn%'
>
>
> >
>
--
Haikal Saadh
Applications Programmer
ICT Resources, TALSS
QUT Kelvin Grove
Email: mailto:[EMAIL PROTECTED]
Skype: skype:carlos-amigos?call
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
- [cfaussie] Re: equivalent to 'does not contain' in SQL Carl Vanderpal
- [cfaussie] Re: equivalent to 'does not contain' in SQ... Chris Velevitch
- [cfaussie] Re: equivalent to 'does not contain' in SQ... rod . higgins