Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding all fields with "enter" as their value 2

Status
Not open for further replies.
mbcmike

mbcmike

Programmer
Sep 9, 2005
34
US
I have a table of data where apparently whoever entered it, happened to hit the enter key in a particular field as opposed to leaving blank. How can I select this field.

EX: Where field ="ENTER"

ENTER of course being what I'm trying to figure out
 
Sort by date Sort by votes
Where Field = char(13) + Char(10)

or, because I get them confused...

Where Field = char(10) + Char(13)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
George, char(13) + Char(10) is the right sequence :) CR LF

Borislav Borissov
 
Upvote 0 Downvote
Uhhh, thanks. I'll bookmark this site to make it easier for me to remember. [bigsmile]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Question, what if the user was on a UNIX based workstation?

“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --
 
Upvote 0 Downvote
sorry dennis but mike's problem was particular with MSSQLSERVER... so its safe to assume that his workstation is a WINDOWS BASED MACHINE...

but if so

either
char(13) + char(10)
or
char(10) + char(13)
or
char(13)
or
char(10)

:)
 
Upvote 0 Downvote
rmnastor my question was this
It this is a web app and there is a textarea
And people can copy paste data or enter data
They are using a linux/freebsd/mac etc etc machine, would that enter be captured the same as from a windows machine
I think not (but I could be wrong)



“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
606
Chris Miller
Chris Miller
bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
250
bharons
bharons
grnzbra
  • Locked
  • Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
1K
gmmastros
gmmastros
grnzbra
  • Locked
  • Question
Why the "WITH" Format 1
Replies
12
Views
203
TamarGranor
TamarGranor
Lidias13
  • Locked
  • Question
Issue trying to find "closest" dated record to a rather complex query (not working)
Replies
1
Views
99
ggriffit
ggriffit

Part and Inventory Search

Sponsor

Back
Top