Sql – special chars select – records with like condition including %
select * from tableName t
where t.ColumnName LIKE ‘%\%%’ escape ‘\’
Advertisements
Tips and Tricks in a world of Mix
Tag Cloud
- Oracle
- Silverlight
- WCF
- Windows 7
- C#
- mvc
- eclipse
- spa
- Javascript
- Fluent Nhibernate
- visual studio
- sql
- PhoneGap
- android
- mdf
- Nhibernate
- error
- vs2010
- sql server
- iis
- 64 bit
- IIS 7
- publish
- Entity Framework
- john papa
- elasticsearch
- Angular4
- Framework 4
- Architecture
- Joomla
- HasMany
- download
- debug
- 404
- IIS 7.5
- .svc
- microsoft
- domainservice
- ODAC
- ODT
- asp.net
- Windows 7 x64 bit
- ActiveDirectory
- Authentication
- RiaService
- Stored Procedure
- SP
- ef
- java
- install
- TFS
- summary
- codecamper
- patterns
- technologies
- solution structure
- terminology of SPA
- Web API
- Angular.js
- Windows Authentication
- angularjs
- nosql
- python
- AWS
- nodejs
- angular2
- mongodb
- Angular
- Maps
- Product Management
- ionic3
- PostSharp 1.5
- ASP.NET AJAX
- Hosting in IIS
- JSON
- Web Services
- .patch
- svn
- CAPTCHA
- Sequence generator
- build 164
- not by id property
- Prism
- WPF
- VS2010 Improvements
- My Summary
- Sql Server 2008
- forgot the sa password
- retrieve sa password
- System.Runtime.InteropServices.COMException
- CodeUITest
- all tables
- array
- MDF file Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed
- connection will be closed
- MDF file Failed to generate a user instance of SQL Server
- forgot Joomla Administrator ( admin ) password
- Joomla admin password restore
- Kill IE
- close ie
- vs
- Linked Server
- innovation
- SqlServer2008
- OptimistickLock
- Transaction.IsolationLevel.ReadCommited
- dll
- Asp.Net Life Cycle
- like
- like with special chars
- Nhiberate
- sequence
- fnh
- flluent nhibernate
- sequence progressed twice
- delete duplicate rows
- delete double records
- HttpWebRequest
- StatusCode
- WebException
- Url Availability
- web service
- ssl
- certificate
- generic
- Instantiate a new generic object
- init generic
- MDA
- unmanaged code exception
- .Wsdl 404
- iis6
- search
- wsdl
- BarCode
- welch allyn
- IT3800
- interceptor
- Upgrade to MVC2
- xVal
- MvcContrib
- reflector
- mvc1
- .aspx
- .asmx
- doesn't recognize
- precompile
- activex
- services
- Toad
- svctraceviewer.exe
- 11g
- debug wcf
- The remote server returned an error: NotFound
- Ajax-enabled Web Service
- external source
- warez-bb.org
- warezbb
- warez-bb
- 2010
- sp1
- Northwind
- pubs
- sqlserver
- 2008
- Microsoft.Web.UI.WebControls.DLL
- web controls
- couldn't load file or assembly
- Officejet 6500
- 64
- Printer setup fails to complete
- 404.17
- mime
- handler mapping
- SAMAccountName
- User
- Identity
- mic
- microphone
- 2104
- InitializeError
- 404.8
- 404.3
- System.ServiceModel.DomainServices
- 2103
- Template
- Spreasheet
- חישוב שעות
- ListView
- GridView
- DataList
- Repeater
- controls
- Formatting
- xaml
- beautify
- Formatting Xaml
- External dlls
- manage dll
- portable
- independent
- connecting fnh to sp
- odp
- version
- ODP.NET nomenclature
- nomenclature
- Permissions
- Shared Folder
- Application Pool Identity
- Across Domain
- ApplicationPoolIdentity
- udt
- ssma
- domain service
- edmx
- ria
- offline
- browser
- crush
- client side
- storage
- light
- database
- COMException
- AD
- 403.14
- scriptResourceHandler
- configSections
- system.web.extensions
- Redirect
- bindings
- Default Document
- Forbidden
- Default Page
- inaccessible files
- insufficient memory
- disk space
- ssrs
- reporting
- logging
- execution
- e4d
- seminar
- x64 bit
- google android tablets
- ASUS Eee Pad Transformer
- ASUS Eee
- Android 3.0 Honeycomb
- MVC3
- templates
