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!

  • Congratulations Chris Miller 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

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
 
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
 
George, char(13) + Char(10) is the right sequence :) CR LF

Borislav Borissov
 
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
 
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" --
 
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)

:)
 
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" --
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top