Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to specify ignore case in when statement in Sybase

Tags:

sql

sybase

How to specify ignore case in a where statement in Sybase?

Basically I want

 select * from _table where _field = 'BUSY'

to return rows if there are any rows with values like 'BuSy' in field _field.

like image 398
Petro Semeniuk Avatar asked Dec 22 '22 20:12

Petro Semeniuk

1 Answers

select * from _table where UPPER(_field) = 'BUSY'
like image 160
Dalmas Avatar answered Jan 10 '23 05:01

Dalmas
Sign in to Comment

Related questions

An expression of non-boolean type specified in a context where a condition is expected, near 'END'
Nested select top 1 in Linq
SQL: query help
MySQL: Get Root Node of Parent-Child Structure
MySQL's alternative to T-SQL's WITH TIES
Multiple row SQL Where clause
Is OData intended for use within Government and Financial envrionments? What security precautions do I need?
Making a more efficient join
Oracle ceil for decimal numbers
Naming Boolean (bit) Values in a SQL db
Add a null value to a Varchar Value
SQL Fastest way to compare two dates (non standard varchar format and datetime)
How do you get a sum() twice from one table with different where clause?
Distinct with select *
selecting top( x ) multiple times
Recursive SQL query to speed up non-indexed query
How can I copy a row into same table with SQL Server 2008
What is the advantage of Sql Data Type numeric?
T-SQL select sum of Two integer column
Using variables in PLSQL SELECT statement

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!